APPS.PON_FBO_PKG dependencies on PON_FORMS_SECTIONS

Line 16: l_form_code pon_forms_sections.form_code%TYPE;

12: p_request_id IN NUMBER,
13: x_result IN OUT NOCOPY VARCHAR2,
14: x_message IN OUT NOCOPY VARCHAR2)
15: AS
16: l_form_code pon_forms_sections.form_code%TYPE;
17: l_form_id pon_forms_sections.form_id%TYPE;
18: is_post_pending VARCHAR2(1);
19: is_docupload_inserted VARCHAR2(1);
20: l_module VARCHAR2(100) := 'VALIDATE_FBO_POSTING';

Line 17: l_form_id pon_forms_sections.form_id%TYPE;

13: x_result IN OUT NOCOPY VARCHAR2,
14: x_message IN OUT NOCOPY VARCHAR2)
15: AS
16: l_form_code pon_forms_sections.form_code%TYPE;
17: l_form_id pon_forms_sections.form_id%TYPE;
18: is_post_pending VARCHAR2(1);
19: is_docupload_inserted VARCHAR2(1);
20: l_module VARCHAR2(100) := 'VALIDATE_FBO_POSTING';
21: l_header_id_orig_amend pon_auction_headers_all.auction_header_id_orig_amend%TYPE;

Line 40: FROM PON_FORMS_SECTIONS

36:
37: BEGIN
38:
39: SELECT form_id INTO l_form_id
40: FROM PON_FORMS_SECTIONS
41: WHERE form_code = 'FED_DOC_UPLOAD'
42: AND STATUS='ACTIVE'
43: AND ROWNUM < 2
44: ORDER BY FORM_VERSION DESC;

Line 90: FROM PON_FORMS_SECTIONS pf

86:
87: BEGIN
88: SELECT pf.form_code
89: INTO l_form_code
90: FROM PON_FORMS_SECTIONS pf
91: WHERE pf.form_id = l_form_id;
92: EXCEPTION
93: WHEN OTHERS THEN
94: x_message := 'PON_FBO_FORM_INV';

Line 193: FROM pon_forms_sections_tl

189: ELSIF p_form_code = 'FED_AWARD' THEN
190: l_form_name := 'Award Notice';
191: ELSE -- Sourcing notices
192: SELECT form_name INTO l_form_name
193: FROM pon_forms_sections_tl
194: WHERE form_id = p_form_id
195: AND LANGUAGE = UserEnv('LANG');
196: END IF;
197:

Line 347: FROM pon_forms_sections

343: l_username := fnd_profile.Value('PON_FBO_USERNAME');
344: l_pwd := fnd_profile.Value('PON_FBO_PASSWORD');
345:
346: SELECT form_code INTO l_form_code
347: FROM pon_forms_sections
348: WHERE form_id = p_form_id;
349:
350: IF l_form_code = 'FED_PRESOL' THEN
351: l_doccat_name := 'ToFedBizOppsPresol';

Line 660: FROM pon_forms_sections

656:
657: LOG_MESSAGE(l_module,'BEGIN paramters '||p_auction_header_id || ' ' || p_form_id);
658:
659: SELECT form_code INTO l_form_code
660: FROM pon_forms_sections
661: WHERE form_id = p_form_id;
662:
663: SELECT MAPPING_FIELD_VALUE_COLUMN
664: INTO FED_PRNUMBER_COL

Line 962: l_form_code pon_forms_sections.form_code%TYPE;

958: x_result IN OUT NOCOPY VARCHAR2,
959: x_message IN OUT NOCOPY VARCHAR2)
960: AS
961:
962: l_form_code pon_forms_sections.form_code%TYPE;
963: l_form_id pon_forms_sections.form_id%TYPE;
964: l_result xmltype;
965:
966: l_module VARCHAR2(100) := 'generate_xml';

Line 963: l_form_id pon_forms_sections.form_id%TYPE;

959: x_message IN OUT NOCOPY VARCHAR2)
960: AS
961:
962: l_form_code pon_forms_sections.form_code%TYPE;
963: l_form_id pon_forms_sections.form_id%TYPE;
964: l_result xmltype;
965:
966: l_module VARCHAR2(100) := 'generate_xml';
967:

Line 982: FROM PON_FORMS_SECTIONS

978: LOG_MESSAGE(l_module,'form code is FED_DOC_UPLOAD');
979: BEGIN
980:
981: SELECT form_id INTO l_form_id
982: FROM PON_FORMS_SECTIONS
983: WHERE form_code = 'FED_DOC_UPLOAD'
984: AND STATUS='ACTIVE'
985: AND ROWNUM < 2
986: ORDER BY FORM_VERSION DESC;

Line 1000: FROM pon_forms_sections

996: ELSE
997: BEGIN
998:
999: SELECT form_code INTO l_form_code
1000: FROM pon_forms_sections
1001: WHERE form_id = p_form_id;
1002:
1003: l_form_id := p_form_id;
1004: