DBA Data[Home] [Help]

APPS.POS_MERGE_SUPPLIER_PKG dependencies on POS_SUPPLIER_UDA_MERGE_GTT

Line 3839: FROM pos_supplier_uda_merge_gtt

3835: x_return_status := fnd_api.g_ret_sts_success;
3836:
3837: SELECT COUNT(1)
3838: INTO l_to_party_cntr
3839: FROM pos_supplier_uda_merge_gtt
3840: WHERE batch_id = p_batch_id
3841: AND to_party_id = p_to_fk_id
3842: AND rownum = 1;
3843:

Line 3845: INSERT INTO pos_supplier_uda_merge_gtt

3841: AND to_party_id = p_to_fk_id
3842: AND rownum = 1;
3843:
3844: IF (l_to_party_cntr = 0) THEN
3845: INSERT INTO pos_supplier_uda_merge_gtt
3846: (batch_id, to_party_id)
3847: VALUES
3848: (p_batch_id, p_to_fk_id);
3849: ELSE

Line 4227: FROM pos_supplier_uda_merge_gtt

4223: x_return_status := fnd_api.g_ret_sts_success;
4224:
4225: SELECT COUNT(1)
4226: INTO l_to_party_cntr
4227: FROM pos_supplier_uda_merge_gtt
4228: WHERE batch_id = p_batch_id
4229: AND to_party_id = p_to_fk_id
4230: AND rownum = 1;
4231:

Line 4233: INSERT INTO pos_supplier_uda_merge_gtt

4229: AND to_party_id = p_to_fk_id
4230: AND rownum = 1;
4231:
4232: IF (l_to_party_cntr = 0) THEN
4233: INSERT INTO pos_supplier_uda_merge_gtt
4234: (batch_id, to_party_id)
4235: VALUES
4236: (p_batch_id, p_to_fk_id);
4237: ELSE