[Home] [Help]
996:
997: CURSOR get_property_value (V_orgn_id NUMBER, V_item_code VARCHAR2, V_element_name VARCHAR2) IS
998: SELECT d.property_name, DECODE(b.property_type_indicator, 'A', a.alpha_value, 'D', a.date_value, 'N', a.number_value, 'F', a.alpha_value ) property_value,
999: d.property_value Proposed_value
1000: FROM gr_inv_item_properties a, gr_properties_b b, gr_xml_properties_map c, gr_prop_chng_temp d
1001: WHERE a.property_id = b.property_id
1002: AND a.property_id = c.property_id
1003: AND b.property_id = c.property_id
1004: AND a.label_code = c.field_name_code
1010: AND c.xml_element = V_element_name
1011: AND d.message_icn = p_message_icn
1012: UNION ALL
1013: SELECT a.property_name, NULL property_value, a.property_value Proposed_value
1014: FROM gr_prop_chng_temp a, gr_xml_properties_map b, mtl_system_items_kfv c
1015: WHERE (c.inventory_item_id, c.organization_id, b.field_name_code, b.property_id ) NOT IN (select INVENTORY_ITEM_ID , ORGANIZATION_ID , label_code, property_id from
1016: gr_inv_item_properties)
1017: AND a.property_name = b.xml_element
1018: AND a.property_name = V_element_name
1024:
1025:
1026: CURSOR get_unmap_property_value (V_orgn_id NUMBER, V_item_code VARCHAR2, V_element_name VARCHAR2) IS
1027: SELECT property_name, NULL property_value, property_value Proposed_value
1028: FROM gr_prop_chng_temp
1029: WHERE property_name NOT IN (SELECT xml_element FROM gr_xml_properties_map)
1030: AND property_name = V_element_name
1031: AND item_code = V_item_code
1032: AND orgn_id = V_orgn_id
1031: AND item_code = V_item_code
1032: AND orgn_id = V_orgn_id
1033: AND message_icn = p_message_icn;
1034:
1035: CURSOR gr_prop_chng_temp IS
1036: SELECT a.orgn_id, nvl(c.organization_code, ' ') orgn_code, a.item_code, b.description item_name, a.property_name
1037: FROM gr_prop_chng_temp a, mtl_system_items_kfv b, mtl_parameters c
1038: WHERE a.orgn_id = b.organization_id
1039: AND a.orgn_id = c.organization_id
1033: AND message_icn = p_message_icn;
1034:
1035: CURSOR gr_prop_chng_temp IS
1036: SELECT a.orgn_id, nvl(c.organization_code, ' ') orgn_code, a.item_code, b.description item_name, a.property_name
1037: FROM gr_prop_chng_temp a, mtl_system_items_kfv b, mtl_parameters c
1038: WHERE a.orgn_id = b.organization_id
1039: AND a.orgn_id = c.organization_id
1040: AND b.organization_id = c.organization_id
1041: AND a.item_code = b.concatenated_segments
1062: WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
1063:
1064: l_item := NULL;
1065:
1066: FOR c1 IN gr_prop_chng_temp LOOP
1067:
1068: IF l_item IS NULL OR l_item <> c1.item_code THEN
1069: FND_MESSAGE.SET_NAME('GR',
1070: 'GR_NOTIFY_TXT');
1165: avalue => l_performer_name );
1166:
1167: /* start the Workflow process */
1168: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
1169: delete from gr_prop_chng_temp where message_icn = p_message_icn;
1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: wf_core.context ('GR_TRD_PRTY_WF',
1173: 'INIT_WF',
1189: -- PROCEDURE:
1190: -- THRDPRTY_INS
1191: --
1192: -- DESCRIPTION:
1193: -- This procedure will insert the details into gr_prop_chng_temp the details from the
1194: -- third party property change inbound message.
1195: --
1196: -- PARAMETERS:
1197: -- p_orgn_id IN NUMBER - Organization ID of an Item
1213: p_item_code IN VARCHAR2,
1214: p_property_name IN VARCHAR2,
1215: p_property_value IN VARCHAR2) IS
1216: BEGIN
1217: INSERT INTO gr_prop_chng_temp
1218: (
1219: MESSAGE_ICN,
1220: ORGN_ID,
1221: ITEM_CODE,