APPS.PON_OPEN_INTERFACE_PVT dependencies on PO_UDA_INTERFACE

Line 277: print_log('Solicitation number is given in po_uda_interface table');

273: WHERE auction_header_id = p_auction_header_id
274: AND attr_group_id = l_solnum_group_id;
275:
276: IF l_sol_num_given = 'Y' THEN
277: print_log('Solicitation number is given in po_uda_interface table');
278:
279: SELECT DATABASE_COLUMN BULK COLLECT INTO solnum_attr
280: FROM EGO_ATTRS_V
281: WHERE APPLICATION_ID=201

Line 3997: /* This loop it to check the usage given in po_uda_interface

3993: FROM pon_auction_item_prices_all
3994: WHERE auction_header_id = x_auction_header_id
3995: AND ROWNUM=1;
3996:
3997: /* This loop it to check the usage given in po_uda_interface
3998: table for complex pricing details matches with the
3999: attribute group id defined for the idc_type and contract_type
4000: given in the lines table
4001: */

Line 4029: 'PO_UDA_INTERFACE',

4025: interface_line_id)
4026: SELECT g_interface_type,
4027: ATTR_GROUP_ID,
4028: 'PON_CLM_COMP_PRIC_ERR',
4029: 'PO_UDA_INTERFACE',
4030: p_batch_id,
4031: interface_line_id
4032: from po_uda_interface
4033: where INTERFACE_REFERENCE_ID = p_batch_id

Line 4032: from po_uda_interface

4028: 'PON_CLM_COMP_PRIC_ERR',
4029: 'PO_UDA_INTERFACE',
4030: p_batch_id,
4031: interface_line_id
4032: from po_uda_interface
4033: where INTERFACE_REFERENCE_ID = p_batch_id
4034: AND INTERFACE_line_id = complex_pricing_rec.line_number
4035: AND attr_group_name = 'PRICING'
4036: AND attr_group_id <> l_attr_group_id;

Line 4149: FROM po_Uda_interface

4145: l_attr_group_id NUMBER;
4146:
4147: CURSOR hdr_uda_attr_group_cur IS
4148: SELECT DISTINCT attr_group_id
4149: FROM po_Uda_interface
4150: WHERE interface_reference_id = p_batch_id
4151: AND ATTR_GROUP_TYPE = p_level;
4152:
4153: CURSOR line_uda_attr_group_cur IS

Line 4155: FROM po_Uda_interface

4151: AND ATTR_GROUP_TYPE = p_level;
4152:
4153: CURSOR line_uda_attr_group_cur IS
4154: SELECT DISTINCT attr_group_id
4155: FROM po_Uda_interface
4156: WHERE interface_reference_id = p_batch_id
4157: AND ATTR_GROUP_TYPE = p_level
4158: AND interface_line_id = p_line_number;
4159:

Line 4169: UPDATE PO_UDA_INTERFACE

4165: OPEN hdr_uda_attr_group_cur;
4166: LOOP
4167: FETCH hdr_uda_attr_group_cur into l_attr_group_id;
4168: EXIT WHEN hdr_uda_attr_group_cur%NOTFOUND;
4169: UPDATE PO_UDA_INTERFACE
4170: SET pk1_value = p_auction_Header_id
4171: WHERE INTERFACE_REFERENCE_ID = p_batch_Id
4172: AND ATTR_GROUP_TYPE=p_level
4173: AND ATTR_GROUP_ID = l_attr_group_id;

Line 4176: FROM po_uda_interface

4172: AND ATTR_GROUP_TYPE=p_level
4173: AND ATTR_GROUP_ID = l_attr_group_id;
4174:
4175: SELECT Count(*) INTO l_count
4176: FROM po_uda_interface
4177: WHERE INTERFACE_REFERENCE_ID = p_batch_Id AND
4178: ATTR_GROUP_TYPE = p_level AND
4179: PROCESS_STATUS = 1 AND
4180: ATTR_GROUP_ID = l_attr_group_id;

Line 4221: UPDATE PO_UDA_INTERFACE

4217: LOOP
4218: FETCH line_uda_attr_group_cur into l_attr_group_id;
4219: EXIT WHEN line_uda_attr_group_cur%NOTFOUND;
4220:
4221: UPDATE PO_UDA_INTERFACE
4222: SET pk1_value = p_auction_Header_id,
4223: pk2_value = p_line_number
4224: WHERE INTERFACE_REFERENCE_ID = p_batch_Id
4225: AND interface_line_id = p_line_number

Line 4230: FROM po_uda_interface

4226: AND ATTR_GROUP_TYPE=p_level
4227: AND ATTR_GROUP_ID = l_attr_group_id;
4228:
4229: SELECT Count(*) INTO l_count
4230: FROM po_uda_interface
4231: WHERE pk1_value = p_auction_Header_id AND
4232: pk2_value = p_line_number AND
4233: INTERFACE_REFERENCE_ID = p_batch_Id AND
4234: interface_line_id = p_line_number AND