APPS.PO_PDOI_HEADER_PROCESS_PVT dependencies on PO_PRINT_FORM_FORMATS

Line 3773: FROM PO_PRINT_FORM_FORMATS

3769: --Try to deafult both standard_from & document_format if there exists an entry of default type
3770: FORALL i IN 1..p_index_tbl.COUNT
3771: UPDATE po_session_gt
3772: SET char1 = ( SELECT standard_form
3773: FROM PO_PRINT_FORM_FORMATS
3774: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3775: decode(char3,
3776: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3777: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',

Line 3786: FROM PO_PRINT_FORM_FORMATS

3782: AND style_id = num2
3783: ),
3784:
3785: char2 = ( SELECT document_format
3786: FROM PO_PRINT_FORM_FORMATS
3787: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3788: decode(char3,
3789: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3790: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',

Line 3807: FROM PO_PRINT_FORM_FORMATS

3803: --Try to default only the document_format from standard_form
3804: FORALL i IN 1..p_index_tbl.COUNT
3805: UPDATE po_session_gt
3806: SET char2 = ( SELECT document_format
3807: FROM PO_PRINT_FORM_FORMATS
3808: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3809: decode(char3,
3810: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3811: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',

Line 3818: FROM PO_PRINT_FORM_FORMATS

3814: AND standard_form = char1
3815: AND trunc(sysdate) <= trunc(nvl(inactive_date, sysdate +1))
3816: AND style_id = num2
3817: AND ( Nvl(default_flag,'N') = 'Y' OR 1 = (SELECT Count(document_format)
3818: FROM PO_PRINT_FORM_FORMATS
3819: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3820: decode(char3,
3821: 'BPA_CALL', 'PO_DEL_ORD_STD_FORM',
3822: 'DELIVERY_ORD', 'PO_DEL_ORD_STD_FORM',