11: PROCEDURE INITIALISE_GLOBALS(p_interface_id IN NUMBER);
12:
13:
14: FUNCTION GET_PKEY(p_pkey1 Number, p_pkey2 Number DEFAULT NULL)
15: RETURN PO_TBL_NUMBER
16: IS
17: l_pkey PO_TBL_NUMBER;
18: BEGIN
19: l_pkey := PO_TBL_NUMBER();
13:
14: FUNCTION GET_PKEY(p_pkey1 Number, p_pkey2 Number DEFAULT NULL)
15: RETURN PO_TBL_NUMBER
16: IS
17: l_pkey PO_TBL_NUMBER;
18: BEGIN
19: l_pkey := PO_TBL_NUMBER();
20: if ( p_pkey2 is null ) then
21: l_pkey.extend(1);
15: RETURN PO_TBL_NUMBER
16: IS
17: l_pkey PO_TBL_NUMBER;
18: BEGIN
19: l_pkey := PO_TBL_NUMBER();
20: if ( p_pkey2 is null ) then
21: l_pkey.extend(1);
22: l_pkey(1) := p_pkey1;
23: else
271: l_src_template_id NUMBER;
272: l_uda_template_date DATE;
273: l_sol_type VARCHAR2(3);
274: l_line_uda_temp_id NUMBER;
275: l_src_pkey PO_TBL_NUMBER;
276: l_tar_pkey PO_TBL_NUMBER;
277: l_lineno_list PO_TBL_NUMBER;
278: l_poline_id NUMBER;
279: l_shp_template_id NUMBER;
272: l_uda_template_date DATE;
273: l_sol_type VARCHAR2(3);
274: l_line_uda_temp_id NUMBER;
275: l_src_pkey PO_TBL_NUMBER;
276: l_tar_pkey PO_TBL_NUMBER;
277: l_lineno_list PO_TBL_NUMBER;
278: l_poline_id NUMBER;
279: l_shp_template_id NUMBER;
280: l_lineloc_list PO_TBL_NUMBER;
273: l_sol_type VARCHAR2(3);
274: l_line_uda_temp_id NUMBER;
275: l_src_pkey PO_TBL_NUMBER;
276: l_tar_pkey PO_TBL_NUMBER;
277: l_lineno_list PO_TBL_NUMBER;
278: l_poline_id NUMBER;
279: l_shp_template_id NUMBER;
280: l_lineloc_list PO_TBL_NUMBER;
281: clm_doc_number VARCHAR2(100);
276: l_tar_pkey PO_TBL_NUMBER;
277: l_lineno_list PO_TBL_NUMBER;
278: l_poline_id NUMBER;
279: l_shp_template_id NUMBER;
280: l_lineloc_list PO_TBL_NUMBER;
281: clm_doc_number VARCHAR2(100);
282: l_return_status VARCHAR2(1);
283: --
284: