APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_ATTRIBUTE_VALUES

Line 352: -- we may need to update po_attribute_values_tlp_draft table

348: l_uom_warning_queue DBMS_SQL.NUMBER_TABLE;
349: l_price_limit_queue DBMS_SQL.NUMBER_TABLE;
350:
351: -- index of the po line for which description is changed;
352: -- we may need to update po_attribute_values_tlp_draft table
353: l_update_desc_queue DBMS_SQL.NUMBER_TABLE;
354: l_sync_attr_tlp_id_tbl PO_TBL_NUMBER;
355:
356: -- lines for which we need to null out the cat based attribute values

Line 653: -- field in po_attribute_values_tlp_draft

649: IF (l_item_desc_tbl(l_index) <> x_lines.item_desc_tbl(i)) THEN
650: l_item_desc_tbl(l_index) := x_lines.item_desc_tbl(i);
651:
652: -- record down the index because we may need to change description
653: -- field in po_attribute_values_tlp_draft
654: l_update_desc_queue(i) := i;
655: END IF;
656: END IF;
657:

Line 979: 5. update description field in po_attribute_values_tlp table if necessary

975: since we want to fail the line if item update failed
976: 2. update line draft table with all changes
977: 3. update or delete price break depending on document type
978: 4. give warning message for lines in l_uom_warning_queue
979: 5. update description field in po_attribute_values_tlp table if necessary
980: 6. null out all cat attribute values in attribute_values and tlp tables
981: */
982: -- 1. update item master with new description
983: l_index := l_update_item_queue.FIRST;

Line 1210: -- 5. update description field in po_attribute_values_tlp table for current lang

1206: END LOOP;
1207:
1208: d_position := 330;
1209:
1210: -- 5. update description field in po_attribute_values_tlp table for current lang
1211: -- a. get rows that need to be synced from txn table to draft table;
1212: FORALL i IN INDICES OF l_update_desc_queue
1213: INSERT INTO po_session_gt
1214: (

Line 1227: FROM po_attribute_values_tlp

1223: attribute_values_tlp_id,
1224: x_lines.draft_id_tbl(i),
1225: x_lines.item_desc_tbl(i),
1226: 'N'
1227: FROM po_attribute_values_tlp
1228: WHERE po_line_id = x_lines.po_line_id_tbl(i)
1229: AND language = USERENV('LANG');
1230:
1231: d_position := 340;

Line 1254: UPDATE po_attribute_values_tlp_draft

1250: d_position := 360;
1251:
1252: -- c. update records in draft table
1253: FORALL i IN 1..l_sync_attr_tlp_id_tbl.COUNT
1254: UPDATE po_attribute_values_tlp_draft
1255: SET description = l_item_desc_tbl(i)
1256: WHERE attribute_values_tlp_id = l_sync_attr_tlp_id_tbl(i)
1257: AND draft_id = l_draft_id_tbl(i);
1258:

Line 1713: -- insert or update attribute values rows into po_attribute_values_draft

1709: WHERE p_attr_values_tlp.error_flag_tbl(i) = FND_API.g_FALSE;
1710:
1711: d_position := 20;
1712:
1713: -- insert or update attribute values rows into po_attribute_values_draft
1714: merge_po_attr_values_tlp_draft
1715: (
1716: p_key => l_key,
1717: p_attr_values_tlp => p_attr_values_tlp

Line 3170: -- into po_attribute_values_draft

3166: --Start of Comments
3167: --Name: merge_po_attr_values_draft
3168: --Function:
3169: -- insert new attribute values or update existing attribute values
3170: -- into po_attribute_values_draft
3171: --Parameters:
3172: --IN:
3173: --p_key
3174: -- key value used to join in MERGE statement

Line 3201: MERGE INTO po_attribute_values_draft PAVD

3197: IF (PO_LOG.d_proc) THEN
3198: PO_LOG.proc_begin(d_module);
3199: END IF;
3200:
3201: MERGE INTO po_attribute_values_draft PAVD
3202: USING (
3203: SELECT
3204: NUM2 AS ATTRIBUTE_VALUES_ID,
3205: NUM3 AS DRAFT_ID,

Line 4195: PO_ATTRIBUTE_VALUES_S.nextval,

4191: PICTURE
4192: )
4193: VALUES
4194: (
4195: PO_ATTRIBUTE_VALUES_S.nextval,
4196: PAVI.DRAFT_ID,
4197: NULL, -- CHANGE_ACCEPTED_FLAG,
4198: NULL, -- DELETE_FLAG,
4199: PAVI.PO_LINE_ID,

Line 4543: -- into po_attribute_values_tlp_draft

4539: --Start of Comments
4540: --Name: merge_po_attr_values_tlp_draft
4541: --Function:
4542: -- insert new attribute tlp values or update existing tlp values
4543: -- into po_attribute_values_tlp_draft
4544: --Parameters:
4545: --IN:
4546: --p_key
4547: -- key value used to join with gt table

Line 4574: MERGE INTO po_attribute_values_tlp_draft PAVTD

4570: IF (PO_LOG.d_proc) THEN
4571: PO_LOG.proc_begin(d_module);
4572: END IF;
4573:
4574: MERGE INTO po_attribute_values_tlp_draft PAVTD
4575: USING (
4576: SELECT
4577: NUM2 AS ATTRIBUTE_VALUES_TLP_ID,
4578: NUM3 AS DRAFT_ID,

Line 5109: PO_ATTRIBUTE_VALUES_TLP_S.nextval,

5105: PROGRAM_UPDATE_DATE
5106: )
5107: VALUES
5108: (
5109: PO_ATTRIBUTE_VALUES_TLP_S.nextval,
5110: PAVTI.DRAFT_ID,
5111: NULL, -- CHANGE_ACCEPTED_FLAG,
5112: NULL, -- DELETE_FLAG,
5113: PAVTI.PO_LINE_ID,

Line 5360: FROM po_attribute_values

5356: l_key,
5357: attribute_values_id,
5358: p_draft_id_tbl(i),
5359: 'N'
5360: FROM po_attribute_values
5361: WHERE po_line_id = p_po_line_id_tbl(i);
5362:
5363: d_position := 10;
5364:

Line 5386: UPDATE po_attribute_values_draft

5382: d_position := 30;
5383:
5384: -- update records in draft table
5385: FORALL i IN 1..l_sync_attr_values_id_tbl.COUNT
5386: UPDATE po_attribute_values_draft
5387: SET TEXT_CAT_ATTRIBUTE1 = NULL,
5388: TEXT_CAT_ATTRIBUTE2 = NULL,
5389: TEXT_CAT_ATTRIBUTE3 = NULL,
5390: TEXT_CAT_ATTRIBUTE4 = NULL,

Line 5513: FROM po_attribute_values_tlp

5509: l_key,
5510: attribute_values_tlp_id,
5511: p_draft_id_tbl(i),
5512: 'N'
5513: FROM po_attribute_values_tlp
5514: WHERE po_line_id = p_po_line_id_tbl(i);
5515:
5516: d_position := 50;
5517:

Line 5539: UPDATE po_attribute_values_tlp_draft

5535: d_position := 70;
5536:
5537: -- update records in draft table
5538: FORALL i IN 1..l_sync_attr_values_tlp_id_tbl.COUNT
5539: UPDATE po_attribute_values_tlp_draft
5540: SET TL_TEXT_CAT_ATTRIBUTE1 = NULL,
5541: TL_TEXT_CAT_ATTRIBUTE2 = NULL,
5542: TL_TEXT_CAT_ATTRIBUTE3 = NULL,
5543: TL_TEXT_CAT_ATTRIBUTE4 = NULL,