DBA Data[Home] [Help]

APPS.PON_SOURCING_OPENAPI_GRP dependencies on STANDARD

Line 286: l_standard_form pon_auction_headers_all.standard_form%TYPE;

282: l_return_status VARCHAR2(1);
283: --
284:
285: --Bug : 16690156
286: l_standard_form pon_auction_headers_all.standard_form%TYPE;
287: l_document_format pon_auction_headers_all.document_format%TYPE;
288:
289:
290: BEGIN

Line 811: /* Bug : 16690156 : Get STANDARD_FORM, DOCUMENT_FORMAT default values */

807: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',
808: 'Got uda_template_id for Line '||l_line_uda_temp_id);
809: end if;
810:
811: /* Bug : 16690156 : Get STANDARD_FORM, DOCUMENT_FORMAT default values */
812: BEGIN
813: SELECT STANDARD_FORM, DOCUMENT_FORMAT
814: INTO l_standard_form, l_document_format
815: FROM po_print_form_formats

Line 813: SELECT STANDARD_FORM, DOCUMENT_FORMAT

809: end if;
810:
811: /* Bug : 16690156 : Get STANDARD_FORM, DOCUMENT_FORMAT default values */
812: BEGIN
813: SELECT STANDARD_FORM, DOCUMENT_FORMAT
814: INTO l_standard_form, l_document_format
815: FROM po_print_form_formats
816: WHERE document_type = 'PO_SOL_STD_FORM' AND default_flag = 'Y' ;
817:

Line 814: INTO l_standard_form, l_document_format

810:
811: /* Bug : 16690156 : Get STANDARD_FORM, DOCUMENT_FORMAT default values */
812: BEGIN
813: SELECT STANDARD_FORM, DOCUMENT_FORMAT
814: INTO l_standard_form, l_document_format
815: FROM po_print_form_formats
816: WHERE document_type = 'PO_SOL_STD_FORM' AND default_flag = 'Y' ;
817:
818: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

Line 820: 'Got default standard_form, document_format : l_standard_form '||l_standard_form||' l_document_format '||l_document_format);

816: WHERE document_type = 'PO_SOL_STD_FORM' AND default_flag = 'Y' ;
817:
818: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
819: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',
820: 'Got default standard_form, document_format : l_standard_form '||l_standard_form||' l_document_format '||l_document_format);
821: end if;
822:
823: EXCEPTION
824: WHEN No_Data_Found THEN

Line 827: 'Default values donot exist for standard form and document format');

823: EXCEPTION
824: WHEN No_Data_Found THEN
825: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
826: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',
827: 'Default values donot exist for standard form and document format');
828: end if;
829: l_standard_form := NULL;
830: l_document_format := NULL;
831: END;

Line 829: l_standard_form := NULL;

825: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
826: fnd_log.string(fnd_log.level_statement,'pon.plsql.pon_sourcing_openapi_grp.Create_Draft_Neg_interface_pvt',
827: 'Default values donot exist for standard form and document format');
828: end if;
829: l_standard_form := NULL;
830: l_document_format := NULL;
831: END;
832: --End Bug : 16690156
833:

Line 897: standard_form, --Bug : 16690156

893: UDA_TEMPLATE_ID, -- uda_template_id
894: UDA_TEMPLATE_DATE,
895: SOLICITATION_TYPE,
896: REVISION,
897: standard_form, --Bug : 16690156
898: document_format --Bug : 16690156
899: )
900: VALUES
901: (x_document_number, -- auction_header_id

Line 959: l_standard_form, --Bug : 16690156

955: l_uda_template_id, -- uda_template_id
956: l_uda_template_date,
957: l_sol_type,
958: 0,
959: l_standard_form, --Bug : 16690156
960: l_document_format --Bug : 16690156
961: );
962:
963: --