APPS.PN_EXP_TO_CAD_ITF dependencies on STANDARD

Line 197: v_standard_type_lookup_code PN_LOCATIONS.STANDARD_TYPE_LOOKUP_CODE%TYPE; --BUG#5359173

193: l_locn_code_from VARCHAR2(90);
194: l_locn_code_to VARCHAR2(90);
195: l_rows INTEGER;
196: l_count INTEGER;
197: v_standard_type_lookup_code PN_LOCATIONS.STANDARD_TYPE_LOOKUP_CODE%TYPE; --BUG#5359173
198:
199: BEGIN
200:
201: fnd_message.set_name ('PN','PN_HRSYNC_LOC_TYPE');

Line 277: L.STANDARD_TYPE_LOOKUP_CODE ---BUG#5359173

273: L.COMMON_AREA_FLAG,
274: L.FUNCTION_TYPE_LOOKUP_CODE, ---BUG#2198182
275: L.ACTIVE_START_DATE,
276: L.ACTIVE_END_DATE,
277: L.STANDARD_TYPE_LOOKUP_CODE ---BUG#5359173
278: FROM
279: PN_LOCATIONS L,
280: PN_ADDRESSES_ALL A
281: WHERE

Line 408: dbms_sql.define_column (l_cursor, 70,v_standard_type_lookup_code,30); ---BUG#5359173

404: dbms_sql.define_column (l_cursor, 66,v_common_area_flag,1);
405: dbms_sql.define_column (l_cursor, 67,v_function_type_lookup_code,30);
406: dbms_sql.define_column (l_cursor, 68,v_active_start_date);
407: dbms_sql.define_column (l_cursor, 69,v_active_end_date);
408: dbms_sql.define_column (l_cursor, 70,v_standard_type_lookup_code,30); ---BUG#5359173
409:
410: l_rows := dbms_sql.execute(l_cursor);
411:
412: LOOP

Line 487: dbms_sql.column_value (l_cursor, 70,v_standard_type_lookup_code); ---BUG#5359173

483: dbms_sql.column_value (l_cursor, 66,v_common_area_flag);
484: dbms_sql.column_value (l_cursor, 67,v_function_type_lookup_code);
485: dbms_sql.column_value (l_cursor, 68,v_active_start_date);
486: dbms_sql.column_value (l_cursor, 69,v_active_end_date);
487: dbms_sql.column_value (l_cursor, 70,v_standard_type_lookup_code); ---BUG#5359173
488: -- Check if data exists in ITF table already.
489:
490: exists_in_itf := 0;
491:

Line 594: STANDARD_TYPE_LOOKUP_CODE, ---BUG#5359173

590: SUITE,
591: COMMON_AREA,
592: COMMON_AREA_FLAG,
593: FUNCTION_TYPE_LOOKUP_CODE,
594: STANDARD_TYPE_LOOKUP_CODE, ---BUG#5359173
595: ACTIVE_START_DATE,
596: ACTIVE_END_DATE
597: )
598: VALUES (

Line 673: v_standard_type_lookup_code, ---BUG#5359173

669: v_SUITE,
670: v_COMMON_AREA,
671: v_COMMON_AREA_FLAG,
672: v_function_type_lookup_code,
673: v_standard_type_lookup_code, ---BUG#5359173
674: v_active_start_date,
675: v_active_end_date
676: );
677:

Line 762: STANDARD_TYPE_LOOKUP_CODE = v_standard_type_lookup_code ---BUG#5359173

758: SUITE = v_suite,
759: COMMON_AREA = v_common_area,
760: COMMON_AREA_FLAG = v_common_area_flag,
761: FUNCTION_TYPE_LOOKUP_CODE = v_function_type_lookup_code, --BUG#2198182
762: STANDARD_TYPE_LOOKUP_CODE = v_standard_type_lookup_code ---BUG#5359173
763: WHERE LOCATION_ID = v_location_id
764: AND active_start_date = v_active_start_date
765: AND active_end_date = v_active_end_date ;
766: