eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_NEGOTIATIONS_SV1 dependencies on PON_BACKING_REQUISITIONS

Line 3702: FROM pon_backing_requisitions

3698: IS
3699:
3700: CURSOR c_get_req_line_id_csr IS
3701: SELECT DISTINCT(requisition_line_id)
3702: FROM pon_backing_requisitions
3703: WHERE auction_header_id = p_auction_header_id;
3704:
3705: l_req_line_ids PO_TBL_NUMBER := PO_TBL_NUMBER();
3706:

Line 3716: --delete pon_backing_requisitions

3712: OPEN c_get_req_line_id_csr;
3713: FETCH c_get_req_line_id_csr BULK collect INTO l_req_line_ids;
3714: CLOSE c_get_req_line_id_csr;
3715:
3716: --delete pon_backing_requisitions
3717: IF p_delete_pbr_yn = 'Y' THEN
3718: DELETE FROM pon_backing_requisitions WHERE auction_header_id = p_auction_header_id;
3719: END IF;
3720:

Line 3718: DELETE FROM pon_backing_requisitions WHERE auction_header_id = p_auction_header_id;

3714: CLOSE c_get_req_line_id_csr;
3715:
3716: --delete pon_backing_requisitions
3717: IF p_delete_pbr_yn = 'Y' THEN
3718: DELETE FROM pon_backing_requisitions WHERE auction_header_id = p_auction_header_id;
3719: END IF;
3720:
3721: --update sol ref in po_requisition_lines_all
3722:

Line 3772: p_table_name IN VARCHAR2 DEFAULT 'PON_BACKING_REQUISITIONS',

3768: p_auction_line_number IN NUMBER,
3769: p_bid_number IN NUMBER DEFAULT NULL,
3770: p_bid_line_number IN NUMBER DEFAULT NULL,
3771: p_requisition_line_id IN NUMBER DEFAULT NULL,
3772: p_table_name IN VARCHAR2 DEFAULT 'PON_BACKING_REQUISITIONS',
3773: x_return_status OUT NOCOPY VARCHAR2,
3774: x_error_msg OUT NOCOPY VARCHAR2,
3775: x_error_code OUT NOCOPY VARCHAR2)
3776: IS

Line 3780: FROM pon_backing_requisitions

3776: IS
3777:
3778: CURSOR c_get_req_line_id_csr IS
3779: SELECT requisition_line_id
3780: FROM pon_backing_requisitions
3781: WHERE auction_header_id = p_auction_header_id
3782: AND EXISTS ( SELECT line_number
3783: FROM pon_auction_item_prices_ALL
3784: WHERE auction_header_id = p_auction_header_id

Line 3798: IF (p_table_name = 'PON_BACKING_REQUISITIONS') THEN

3794: IF p_requisition_line_id IS NOT NULL THEN
3795:
3796: l_req_line_ids(1) := p_requisition_line_id;
3797:
3798: IF (p_table_name = 'PON_BACKING_REQUISITIONS') THEN
3799: DELETE FROM pon_backing_requisitions
3800: WHERE auction_header_id = p_auction_header_id
3801: AND line_number = p_auction_line_number
3802: AND requisition_line_id = p_requisition_line_id;

Line 3799: DELETE FROM pon_backing_requisitions

3795:
3796: l_req_line_ids(1) := p_requisition_line_id;
3797:
3798: IF (p_table_name = 'PON_BACKING_REQUISITIONS') THEN
3799: DELETE FROM pon_backing_requisitions
3800: WHERE auction_header_id = p_auction_header_id
3801: AND line_number = p_auction_line_number
3802: AND requisition_line_id = p_requisition_line_id;
3803: else

Line 3814: --delete pon_backing_requisitions for that line and all its sublines if its a clin.

3810: end if;
3811:
3812: ELSE
3813:
3814: --delete pon_backing_requisitions for that line and all its sublines if its a clin.
3815: DELETE FROM pon_backing_requisitions
3816: WHERE auction_header_id = p_auction_header_id
3817: AND line_number = p_auction_line_number;
3818:

Line 3815: DELETE FROM pon_backing_requisitions

3811:
3812: ELSE
3813:
3814: --delete pon_backing_requisitions for that line and all its sublines if its a clin.
3815: DELETE FROM pon_backing_requisitions
3816: WHERE auction_header_id = p_auction_header_id
3817: AND line_number = p_auction_line_number;
3818:
3819: END IF;

Line 3824: IF (p_table_name = 'PON_BACKING_REQUISITIONS') THEN

3820:
3821: /*IF the deleted req line id is not referred anywhere other than in this line for the
3822: current auction_header_id then update sol ref in po_requisition_lines_all*/
3823:
3824: IF (p_table_name = 'PON_BACKING_REQUISITIONS') THEN
3825:
3826: UPDATE po_requisition_lines_all prl SET auction_header_id = NULL,
3827: auction_line_number = NULL,
3828: auction_display_number = NULL,

Line 3834: FROM pon_backing_requisitions pbr

3830: last_updated_by = FND_GLOBAL.USER_ID,
3831: last_update_login = FND_GLOBAL.LOGIN_ID
3832: WHERE auction_header_id = p_auction_header_id
3833: AND NOT EXISTS (SELECT requisition_line_id
3834: FROM pon_backing_requisitions pbr
3835: WHERE auction_header_id = p_auction_header_id
3836: AND prl.requisition_line_id = pbr.requisition_line_id
3837: GROUP BY requisition_line_id )
3838: RETURNING requisition_line_id BULK COLLECT INTO l_req_line_ids;

Line 3894: FROM pon_backing_requisitions

3890: IS
3891:
3892: CURSOR c_deleted_pr_ref_csr IS
3893: SELECT DISTINCT(requisition_line_id)
3894: FROM pon_backing_requisitions
3895: WHERE auction_header_id = p_old_auction_id
3896: MINUS (SELECT requisition_line_id
3897: FROM pon_backing_requisitions
3898: WHERE auction_header_id = p_new_auction_id);

Line 3897: FROM pon_backing_requisitions

3893: SELECT DISTINCT(requisition_line_id)
3894: FROM pon_backing_requisitions
3895: WHERE auction_header_id = p_old_auction_id
3896: MINUS (SELECT requisition_line_id
3897: FROM pon_backing_requisitions
3898: WHERE auction_header_id = p_new_auction_id);
3899:
3900: l_req_line_ids number_table;
3901:

Line 3915: FROM pon_backing_requisitions pbr

3911: /*Update ref of auction in po_requisition_lines_all table only for those lines copied to the new auction*/
3912:
3913: UPDATE po_requisition_lines_all prl SET auction_header_id = p_new_auction_id
3914: WHERE EXISTS (SELECT DISTINCT(requisition_line_id)
3915: FROM pon_backing_requisitions pbr
3916: WHERE auction_header_id = p_new_auction_id
3917: AND prl.requisition_line_id = pbr.requisition_line_id);
3918:
3919: /* For deleted PR references remove sol references in po_requisition_lines_all*/

Line 3927: FROM pon_backing_requisitions

3923: last_update_date = SYSDATE,
3924: last_updated_by = FND_GLOBAL.USER_ID,
3925: last_update_login = FND_GLOBAL.LOGIN_ID
3926: WHERE EXISTS (SELECT DISTINCT(requisition_line_id)
3927: FROM pon_backing_requisitions
3928: WHERE auction_header_id = p_old_auction_id
3929: MINUS (SELECT requisition_line_id
3930: FROM pon_backing_requisitions
3931: WHERE auction_header_id = p_new_auction_id))

Line 3930: FROM pon_backing_requisitions

3926: WHERE EXISTS (SELECT DISTINCT(requisition_line_id)
3927: FROM pon_backing_requisitions
3928: WHERE auction_header_id = p_old_auction_id
3929: MINUS (SELECT requisition_line_id
3930: FROM pon_backing_requisitions
3931: WHERE auction_header_id = p_new_auction_id))
3932: RETURNING requisition_line_id BULK COLLECT INTO l_req_line_ids ;
3933:
3934: /*Put the lines back to pool if the entire structure is out of pool*/