DBA Data[Home] [Help]

APPS.PO_UDA_IMPORT_PKG dependencies on PO_LINES_ALL_EXT_TL

Line 2498: -- po_lines_all_ext_b and po_lines_all_ext_tl.

2494: FROM fnd_languages
2495: WHERE INSTALLED_FLAG in ('I', 'B');
2496:
2497: --The import UDA api doesnt take care of inserting delta archove and old archive record in
2498: -- po_lines_all_ext_b and po_lines_all_ext_tl.
2499: -- So these records are inserted / updated here
2500: -- Update the existing record if record exists
2501: IF l_records_exist = 'Y'
2502: THEN

Line 3191: --Update delta archive record in po_lines_all_ext_tl

3187: -- Inserting/Updating records in po_lines_all_ext_b table
3188: FOR j IN 1..l_language_code_tbl.Count()
3189: LOOP
3190:
3191: --Update delta archive record in po_lines_all_ext_tl
3192: IF l_records_exist = 'Y'
3193: THEN
3194: UPDATE po_lines_all_ext_tl
3195: SET ( EXTENSION_ID,

Line 3194: UPDATE po_lines_all_ext_tl

3190:
3191: --Update delta archive record in po_lines_all_ext_tl
3192: IF l_records_exist = 'Y'
3193: THEN
3194: UPDATE po_lines_all_ext_tl
3195: SET ( EXTENSION_ID,
3196: ATTR_GROUP_ID,
3197: PO_LINE_ID,
3198: DATA_LEVEL_ID,

Line 3235: INSERT INTO po_lines_all_ext_tl

3231:
3232: ELSE
3233:
3234: --insert into tl table
3235: INSERT INTO po_lines_all_ext_tl
3236: (
3237: EXTENSION_ID,
3238: ATTR_GROUP_ID,
3239: PO_LINE_ID,

Line 3274: INSERT INTO po_lines_all_ext_tl

3270: AND draft_id = l_draft_id_tbl(i) * -1
3271: AND data_level_id = (SELECT data_level_id FROM ego_data_level_b WHERE DATA_LEVEL_NAME = 'PO_LINE_CP_DELTA_ARCHIVE');
3272:
3273: --Insert old arcive record in tl table
3274: INSERT INTO po_lines_all_ext_tl
3275: (
3276: EXTENSION_ID,
3277: ATTR_GROUP_ID,
3278: PO_LINE_ID,