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_DOCUMENT_CANCEL_PVT dependencies on PO_LINES

Line 714: p_user_id IN po_lines.last_updated_by%TYPE,

710: p_entity_level IN VARCHAR2,
711: p_entity_id IN NUMBER,
712: p_document_type IN VARCHAR2,
713: p_recreate_demand IN VARCHAR2,
714: p_user_id IN po_lines.last_updated_by%TYPE,
715: p_login_id IN po_lines.last_update_login%TYPE,
716: x_return_status OUT NOCOPY VARCHAR2)
717: IS
718:

Line 715: p_login_id IN po_lines.last_update_login%TYPE,

711: p_entity_id IN NUMBER,
712: p_document_type IN VARCHAR2,
713: p_recreate_demand IN VARCHAR2,
714: p_user_id IN po_lines.last_updated_by%TYPE,
715: p_login_id IN po_lines.last_update_login%TYPE,
716: x_return_status OUT NOCOPY VARCHAR2)
717: IS
718:
719: d_api_name CONSTANT VARCHAR2(30) := 'update_dist_cancel';

Line 919: p_user_id IN po_lines.last_updated_by%TYPE,

915: p_entity_level IN VARCHAR2,
916: p_entity_id IN NUMBER,
917: p_action_date IN DATE,
918: p_document_type IN VARCHAR2,
919: p_user_id IN po_lines.last_updated_by%TYPE,
920: p_login_id IN po_lines.last_update_login%TYPE,
921: x_return_status IN OUT NOCOPY VARCHAR2)
922: IS
923:

Line 920: p_login_id IN po_lines.last_update_login%TYPE,

916: p_entity_id IN NUMBER,
917: p_action_date IN DATE,
918: p_document_type IN VARCHAR2,
919: p_user_id IN po_lines.last_updated_by%TYPE,
920: p_login_id IN po_lines.last_update_login%TYPE,
921: x_return_status IN OUT NOCOPY VARCHAR2)
922: IS
923:
924: d_api_name CONSTANT VARCHAR2(30) := 'update_ship_cancel';

Line 1128: UPDATE po_lines pol

1124: END IF;
1125:
1126: l_progress := '001' ;
1127:
1128: UPDATE po_lines pol
1129: SET pol.quantity =(SELECT SUM(
1130: NVL(poll.quantity,0)
1131: - NVL(poll.quantity_cancelled, 0))
1132: FROM po_line_locations POLL

Line 1147: PO_DEBUG.debug_var(d_module, l_progress, 'Quanity Updated in PO Lines table', SQL%ROWCOUNT);

1143: WHERE poll2.po_line_id=pol.po_line_id
1144: AND poll2.payment_type IS NOT NULL);
1145:
1146: IF g_debug_stmt THEN
1147: PO_DEBUG.debug_var(d_module, l_progress, 'Quanity Updated in PO Lines table', SQL%ROWCOUNT);
1148: END IF;
1149:
1150:
1151: l_progress := '002' ;

Line 1157: UPDATE po_lines pol

1153: -- For Qty-based lines, only do the update of line price for the
1154: -- Complex Work Qty Milestone case.
1155: -- Cancellation of normal PO shipment does not change Line Price
1156:
1157: UPDATE po_lines pol
1158: SET pol.unit_price =
1159: (SELECT SUM(poll.price_override)
1160: FROM po_line_locations POLL
1161: WHERE poll.po_line_id = pol.po_line_id

Line 1181: PO_DEBUG.debug_var(d_module, l_progress, 'Price Updated in PO Lines table', SQL%ROWCOUNT);

1177:
1178:
1179:
1180: IF g_debug_stmt THEN
1181: PO_DEBUG.debug_var(d_module, l_progress, 'Price Updated in PO Lines table', SQL%ROWCOUNT);
1182: END IF;
1183:
1184:
1185: l_progress := '003' ;

Line 1192: UPDATE po_lines pol

1188: -- of Quantity and Amount based line locations (pay item case).
1189: -- The logic below will also work for the non-mixed case, as
1190: -- exists with non-Complex Work shipments
1191:
1192: UPDATE po_lines pol
1193: SET pol.amount= (SELECT SUM(DECODE(
1194: POLL.amount,
1195: NULL,
1196: --Quantity or Amount Line Locations

Line 1213: PO_DEBUG.debug_var(d_module, l_progress, 'Amount Updated in PO Lines table', SQL%ROWCOUNT);

1209: AND pol.order_type_lookup_code in ('FIXED PRICE', 'RATE');
1210:
1211:
1212: IF g_debug_stmt THEN
1213: PO_DEBUG.debug_var(d_module, l_progress, 'Amount Updated in PO Lines table', SQL%ROWCOUNT);
1214: END IF;
1215:
1216:
1217:

Line 1238: -- Updates the Cancel details on PO Lines if the entity being canceled is

1234: --Name: update_line_cancel
1235:
1236: --Function:
1237: --
1238: -- Updates the Cancel details on PO Lines if the entity being canceled is
1239: -- PO/PA Header, PO/PA Line
1240:
1241: -- Updates the following columns :
1242: -- Before Funds Control call

Line 1288: p_user_id IN po_lines.last_updated_by%TYPE,

1284: p_cancel_reason IN VARCHAR2,
1285: p_entity_level IN VARCHAR2,
1286: p_entity_id IN NUMBER,
1287: p_action_date IN DATE,
1288: p_user_id IN po_lines.last_updated_by%TYPE,
1289: p_login_id IN po_lines.last_update_login%TYPE,
1290: p_note_to_vendor IN VARCHAR2,
1291: x_return_status OUT NOCOPY VARCHAR2)
1292: IS

Line 1289: p_login_id IN po_lines.last_update_login%TYPE,

1285: p_entity_level IN VARCHAR2,
1286: p_entity_id IN NUMBER,
1287: p_action_date IN DATE,
1288: p_user_id IN po_lines.last_updated_by%TYPE,
1289: p_login_id IN po_lines.last_update_login%TYPE,
1290: p_note_to_vendor IN VARCHAR2,
1291: x_return_status OUT NOCOPY VARCHAR2)
1292: IS
1293:

Line 1334: UPDATE po_lines pol

1330: IF p_fc_level = c_before_FC THEN
1331:
1332: l_progress := '001' ;
1333:
1334: UPDATE po_lines pol
1335: SET pol.cancel_flag = 'I',
1336: --Bug 16575765: CANCEL_DATE is always stamped(LINE) as sysdate.
1337: --pol.cancel_date = p_action_date,
1338: pol.cancel_date = SYSDATE,

Line 1379: FROM po_lines

1375: WHERE nvl(pol.cancel_flag,'N') = 'N'
1376: AND nvl(pol.closed_code,'OPEN') <> 'FINALLY CLOSED'
1377: AND pol.po_line_id IN (
1378: SELECT po_line_id
1379: FROM po_lines
1380: WHERE po_line_id= p_entity_id
1381: AND p_entity_level=c_entity_level_LINE
1382: UNION ALL
1383: SELECT po_line_id

Line 1384: FROM po_lines

1380: WHERE po_line_id= p_entity_id
1381: AND p_entity_level=c_entity_level_LINE
1382: UNION ALL
1383: SELECT po_line_id
1384: FROM po_lines
1385: WHERE po_header_id= p_entity_id
1386: AND p_entity_level=c_entity_level_HEADER);
1387:
1388: ELSE

Line 1391: UPDATE po_lines POl

1387:
1388: ELSE
1389: l_progress := '002' ;
1390:
1391: UPDATE po_lines POl
1392: SET pol.cancel_flag = 'Y'
1393: WHERE nvl(pol.cancel_flag,'N') = 'I'
1394: AND nvl(pol.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1395: AND pol.po_line_id IN (

Line 1397: FROM po_lines

1393: WHERE nvl(pol.cancel_flag,'N') = 'I'
1394: AND nvl(pol.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1395: AND pol.po_line_id IN (
1396: SELECT po_line_id
1397: FROM po_lines
1398: WHERE po_line_id= p_entity_id
1399: AND p_entity_level=c_entity_level_LINE
1400: UNION ALL
1401: SELECT po_line_id

Line 1402: FROM po_lines

1398: WHERE po_line_id= p_entity_id
1399: AND p_entity_level=c_entity_level_LINE
1400: UNION ALL
1401: SELECT po_line_id
1402: FROM po_lines
1403: WHERE po_header_id= p_entity_id
1404: AND p_entity_level=c_entity_level_HEADER);
1405:
1406:

Line 1411: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated in PO Lines table', SQL%ROWCOUNT);

1407: END IF;
1408:
1409:
1410: IF g_debug_stmt THEN
1411: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated in PO Lines table', SQL%ROWCOUNT);
1412: END IF;
1413:
1414:
1415: EXCEPTION

Line 1478: p_user_id IN po_lines.last_updated_by%TYPE,

1474: p_init_msg_list IN VARCHAR2,
1475: p_fc_level IN VARCHAR2,
1476: p_entity_id IN NUMBER,
1477: p_action_date IN DATE,
1478: p_user_id IN po_lines.last_updated_by%TYPE,
1479: p_login_id IN po_lines.last_update_login%TYPE,
1480: p_note_to_vendor IN VARCHAR2,
1481: x_return_status OUT NOCOPY VARCHAR2)
1482: IS

Line 1479: p_login_id IN po_lines.last_update_login%TYPE,

1475: p_fc_level IN VARCHAR2,
1476: p_entity_id IN NUMBER,
1477: p_action_date IN DATE,
1478: p_user_id IN po_lines.last_updated_by%TYPE,
1479: p_login_id IN po_lines.last_update_login%TYPE,
1480: p_note_to_vendor IN VARCHAR2,
1481: x_return_status OUT NOCOPY VARCHAR2)
1482: IS
1483:

Line 1625: p_user_id IN po_lines.last_updated_by%TYPE,

1621: p_fc_level IN VARCHAR2,
1622: p_action_date IN DATE,
1623: p_cancel_reason IN VARCHAR2,
1624: p_note_to_vendor IN VARCHAR2,
1625: p_user_id IN po_lines.last_updated_by%TYPE,
1626: p_login_id IN po_lines.last_update_login%TYPE,
1627: x_return_status OUT NOCOPY VARCHAR2)
1628: IS
1629:

Line 1626: p_login_id IN po_lines.last_update_login%TYPE,

1622: p_action_date IN DATE,
1623: p_cancel_reason IN VARCHAR2,
1624: p_note_to_vendor IN VARCHAR2,
1625: p_user_id IN po_lines.last_updated_by%TYPE,
1626: p_login_id IN po_lines.last_update_login%TYPE,
1627: x_return_status OUT NOCOPY VARCHAR2)
1628: IS
1629:
1630: d_api_name CONSTANT VARCHAR2(30) := 'update_rel_header_cancel';

Line 1742: -- then updates PO Lines/Shipments/Distributions

1738: -- 4. If the Contract Header is Canceled i.e. entity_level=HEADER and
1739: -- document_type =PA nd docuemnt_subtype=CONTRACT then updates PA Header
1740: --
1741: -- 5. If the PO Line is Canceled i.e. entity_level=LINE and document_type =PO
1742: -- then updates PO Lines/Shipments/Distributions
1743: --
1744: -- 6. If the PA Line is Canceled i.e. entity_level=LINE and document_type =PO
1745: -- then updates PA Line
1746: --

Line 1786: p_user_id IN po_lines.last_updated_by%TYPE,

1782: p_cancel_reason IN VARCHAR2,
1783: p_fc_level IN VARCHAR2,
1784: p_recreate_demand IN VARCHAR2,
1785: p_note_to_vendor IN VARCHAR2,
1786: p_user_id IN po_lines.last_updated_by%TYPE,
1787: p_login_id IN po_lines.last_update_login%TYPE,
1788: x_return_status OUT NOCOPY VARCHAR2,
1789: x_msg_data OUT NOCOPY VARCHAR2)
1790:

Line 1787: p_login_id IN po_lines.last_update_login%TYPE,

1783: p_fc_level IN VARCHAR2,
1784: p_recreate_demand IN VARCHAR2,
1785: p_note_to_vendor IN VARCHAR2,
1786: p_user_id IN po_lines.last_updated_by%TYPE,
1787: p_login_id IN po_lines.last_update_login%TYPE,
1788: x_return_status OUT NOCOPY VARCHAR2,
1789: x_msg_data OUT NOCOPY VARCHAR2)
1790:
1791: IS

Line 2854: po_lines POL

2850: PORL.ITEM_ID)
2851: INTO x_uom_conv
2852: FROM PO_REQUISITION_LINES_ALL PORL,
2853: po_line_locations POLL ,
2854: po_lines POL
2855: WHERE PORL.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
2856: AND POLL.PO_LINE_ID = POL.PO_LINE_ID
2857: AND PORL.REQUISITION_LINE_ID = p_req_line_id ;
2858:

Line 2867: po_lines POL

2863: PORL.ITEM_ID)
2864: INTO x_uom_conv
2865: FROM PO_REQUISITION_LINES_ALL PORL,
2866: po_line_locations POLL ,
2867: po_lines POL
2868: WHERE (-1)*PORL.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
2869: AND POLL.PO_LINE_ID = POL.PO_LINE_ID
2870: and porl.requisition_line_id = p_req_line_id ;
2871: END IF;

Line 3027: p_user_id IN po_lines.last_updated_by%TYPE,

3023: p_api_version IN NUMBER,
3024: p_init_msg_list IN VARCHAR2,
3025: p_req_line_id IN NUMBER,
3026: p_recreate_demand_flag IN VARCHAR2,
3027: p_user_id IN po_lines.last_updated_by%TYPE,
3028: p_login_id IN po_lines.last_update_login%TYPE,
3029: p_is_new_req_line IN VARCHAR2,
3030: x_msg_data OUT NOCOPY VARCHAR2,
3031: x_return_status OUT NOCOPY VARCHAR2)

Line 3028: p_login_id IN po_lines.last_update_login%TYPE,

3024: p_init_msg_list IN VARCHAR2,
3025: p_req_line_id IN NUMBER,
3026: p_recreate_demand_flag IN VARCHAR2,
3027: p_user_id IN po_lines.last_updated_by%TYPE,
3028: p_login_id IN po_lines.last_update_login%TYPE,
3029: p_is_new_req_line IN VARCHAR2,
3030: x_msg_data OUT NOCOPY VARCHAR2,
3031: x_return_status OUT NOCOPY VARCHAR2)
3032: IS

Line 3244: po_lines POL

3240: SYSDATE ,
3241: p_user_id ,
3242: p_login_id
3243: FROM po_line_locations POLL,
3244: po_lines POL
3245: WHERE PORL.line_location_id = POLL.line_location_id
3246: AND POLL.po_line_id = POL.po_line_id)
3247: WHERE PORL.requisition_line_id = (
3248: SELECT ((-1) * PORL_NEW.parent_req_line_id)

Line 3513: p_user_id IN po_lines.last_updated_by%TYPE,

3509: p_api_version IN NUMBER,
3510: p_init_msg_list IN VARCHAR2,
3511: p_old_line_id IN NUMBER,
3512: p_line_quantity IN NUMBER,
3513: p_user_id IN po_lines.last_updated_by%TYPE,
3514: p_login_id IN po_lines.last_update_login%TYPE,
3515: x_new_line_id OUT NOCOPY NUMBER,
3516: x_return_status OUT NOCOPY VARCHAR2,
3517: x_msg_data OUT NOCOPY VARCHAR2)

Line 3514: p_login_id IN po_lines.last_update_login%TYPE,

3510: p_init_msg_list IN VARCHAR2,
3511: p_old_line_id IN NUMBER,
3512: p_line_quantity IN NUMBER,
3513: p_user_id IN po_lines.last_updated_by%TYPE,
3514: p_login_id IN po_lines.last_update_login%TYPE,
3515: x_new_line_id OUT NOCOPY NUMBER,
3516: x_return_status OUT NOCOPY VARCHAR2,
3517: x_msg_data OUT NOCOPY VARCHAR2)
3518:

Line 3780: po_lines POL

3776: PORL.CATALOG_SOURCE
3777: FROM
3778: PO_REQUISITION_LINES_ALL PORL,
3779: po_line_locations POLL ,
3780: po_lines POL
3781: WHERE
3782: PORL.REQUISITION_LINE_ID = p_old_line_id
3783: AND PORL.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
3784: AND POLL.PO_LINE_ID = POL.PO_LINE_ID;

Line 3866: p_user_id IN po_lines.last_updated_by%TYPE,

3862: PROCEDURE create_req_dist(
3863: p_api_version IN NUMBER,
3864: p_init_msg_list IN VARCHAR2,
3865: p_req_line_id IN NUMBER,
3866: p_user_id IN po_lines.last_updated_by%TYPE,
3867: p_login_id IN po_lines.last_update_login%TYPE,
3868: x_return_status OUT NOCOPY VARCHAR2,
3869: x_msg_data OUT NOCOPY VARCHAR2)
3870:

Line 3867: p_login_id IN po_lines.last_update_login%TYPE,

3863: p_api_version IN NUMBER,
3864: p_init_msg_list IN VARCHAR2,
3865: p_req_line_id IN NUMBER,
3866: p_user_id IN po_lines.last_updated_by%TYPE,
3867: p_login_id IN po_lines.last_update_login%TYPE,
3868: x_return_status OUT NOCOPY VARCHAR2,
3869: x_msg_data OUT NOCOPY VARCHAR2)
3870:
3871: IS

Line 4172: p_user_id IN po_lines.last_updated_by%TYPE,

4168: p_cancel_reason IN VARCHAR2,
4169: p_fc_level IN VARCHAR2,
4170: p_recreate_demand IN VARCHAR2,
4171: p_req_enc_flag IN VARCHAR2,
4172: p_user_id IN po_lines.last_updated_by%TYPE,
4173: p_login_id IN po_lines.last_update_login%TYPE,
4174: x_is_new_line IN OUT NOCOPY VARCHAR2,
4175: x_return_status OUT NOCOPY VARCHAR2,
4176: x_msg_data OUT NOCOPY VARCHAR2,

Line 4173: p_login_id IN po_lines.last_update_login%TYPE,

4169: p_fc_level IN VARCHAR2,
4170: p_recreate_demand IN VARCHAR2,
4171: p_req_enc_flag IN VARCHAR2,
4172: p_user_id IN po_lines.last_updated_by%TYPE,
4173: p_login_id IN po_lines.last_update_login%TYPE,
4174: x_is_new_line IN OUT NOCOPY VARCHAR2,
4175: x_return_status OUT NOCOPY VARCHAR2,
4176: x_msg_data OUT NOCOPY VARCHAR2,
4177: x_req_line_id_tbl OUT NOCOPY PO_ReqChangeRequestWF_PVT.ReqLineID_tbl_type)

Line 4405: po_lines pol,

4401: WHERE porl.requisition_line_id = PORD.requisition_line_id
4402: AND porl.blanket_po_header_id IS NULL)
4403: AND EXISTS (SELECT 1
4404: FROM po_distributions_all poda,
4405: po_lines pol,
4406: po_distributions_all pod
4407: WHERE poda.po_header_id = pol.from_header_id
4408: AND pol.po_line_id = pod.po_line_id
4409: AND pod.req_distribution_id = pord.distribution_id

Line 4453: po_lines POL

4449: SYSDATE ,
4450: p_user_id ,
4451: p_login_id
4452: FROM po_line_locations POLL,
4453: po_lines POL
4454: WHERE PORL.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
4455: AND POLL.PO_LINE_ID = POL.PO_LINE_ID
4456: )
4457: WHERE PORL.REQUISITION_LINE_ID = x_req_line_id_tbl(i);

Line 4709: p_user_id IN po_lines.last_updated_by%TYPE,

4705: p_recreate_flag IN VARCHAR2,
4706: p_note_to_vendor IN VARCHAR2,
4707: p_req_enc_flag IN VARCHAR2,
4708: p_source IN VARCHAR2,
4709: p_user_id IN po_lines.last_updated_by%TYPE,
4710: p_login_id IN po_lines.last_update_login%TYPE,
4711: x_is_new_line IN OUT NOCOPY VARCHAR2,
4712: x_return_status IN OUT NOCOPY VARCHAR2,
4713: x_msg_data IN OUT NOCOPY VARCHAR2)

Line 4710: p_login_id IN po_lines.last_update_login%TYPE,

4706: p_note_to_vendor IN VARCHAR2,
4707: p_req_enc_flag IN VARCHAR2,
4708: p_source IN VARCHAR2,
4709: p_user_id IN po_lines.last_updated_by%TYPE,
4710: p_login_id IN po_lines.last_update_login%TYPE,
4711: x_is_new_line IN OUT NOCOPY VARCHAR2,
4712: x_return_status IN OUT NOCOPY VARCHAR2,
4713: x_msg_data IN OUT NOCOPY VARCHAR2)
4714: IS

Line 4953: p_user_id IN po_lines.last_updated_by%TYPE,

4949: p_cancel_reason IN VARCHAR2,
4950: p_recreate_demand IN VARCHAR2,
4951: p_req_enc_flag IN VARCHAR2,
4952: p_note_to_vendor IN VARCHAR2,
4953: p_user_id IN po_lines.last_updated_by%TYPE,
4954: p_login_id IN po_lines.last_update_login%TYPE,
4955: x_is_new_line IN OUT NOCOPY VARCHAR2,
4956: x_return_status IN OUT NOCOPY VARCHAR2,
4957: x_msg_data IN OUT NOCOPY VARCHAR2)

Line 4954: p_login_id IN po_lines.last_update_login%TYPE,

4950: p_recreate_demand IN VARCHAR2,
4951: p_req_enc_flag IN VARCHAR2,
4952: p_note_to_vendor IN VARCHAR2,
4953: p_user_id IN po_lines.last_updated_by%TYPE,
4954: p_login_id IN po_lines.last_update_login%TYPE,
4955: x_is_new_line IN OUT NOCOPY VARCHAR2,
4956: x_return_status IN OUT NOCOPY VARCHAR2,
4957: x_msg_data IN OUT NOCOPY VARCHAR2)
4958:

Line 5129: l_user_id po_lines.last_updated_by%TYPE := -1;

5125: d_api_version CONSTANT NUMBER := 1.0;
5126: d_module CONSTANT VARCHAR2(100) := g_module_prefix|| d_api_name;
5127:
5128: l_progress VARCHAR2(8) := '000' ;
5129: l_user_id po_lines.last_updated_by%TYPE := -1;
5130: l_login_id po_lines.last_update_login%TYPE := -1;
5131:
5132:
5133:

Line 5130: l_login_id po_lines.last_update_login%TYPE := -1;

5126: d_module CONSTANT VARCHAR2(100) := g_module_prefix|| d_api_name;
5127:
5128: l_progress VARCHAR2(8) := '000' ;
5129: l_user_id po_lines.last_updated_by%TYPE := -1;
5130: l_login_id po_lines.last_update_login%TYPE := -1;
5131:
5132:
5133:
5134: BEGIN

Line 5296: p_user_id IN po_lines.last_updated_by%TYPE,

5292: p_document_type IN VARCHAR2,
5293: p_doc_subtype IN VARCHAR2,
5294: p_action_date IN DATE,
5295: p_reason IN VARCHAR2,
5296: p_user_id IN po_lines.last_updated_by%TYPE,
5297: p_login_id IN po_lines.last_update_login%TYPE,
5298: p_caller IN VARCHAR2,
5299: x_return_status IN OUT NOCOPY VARCHAR2,
5300: x_msg_data IN OUT NOCOPY VARCHAR2)

Line 5297: p_login_id IN po_lines.last_update_login%TYPE,

5293: p_doc_subtype IN VARCHAR2,
5294: p_action_date IN DATE,
5295: p_reason IN VARCHAR2,
5296: p_user_id IN po_lines.last_updated_by%TYPE,
5297: p_login_id IN po_lines.last_update_login%TYPE,
5298: p_caller IN VARCHAR2,
5299: x_return_status IN OUT NOCOPY VARCHAR2,
5300: x_msg_data IN OUT NOCOPY VARCHAR2)
5301:

Line 5648: p_user_id IN po_lines.last_updated_by%TYPE,

5644: p_entity_id IN NUMBER,
5645: p_doc_id IN NUMBER,
5646: p_document_type IN VARCHAR2,
5647: p_doc_subtype IN VARCHAR2,
5648: p_user_id IN po_lines.last_updated_by%TYPE,
5649: p_login_id IN po_lines.last_update_login%TYPE,
5650: x_return_status OUT NOCOPY VARCHAR2,
5651: x_msg_data OUT NOCOPY VARCHAR2)
5652:

Line 5649: p_login_id IN po_lines.last_update_login%TYPE,

5645: p_doc_id IN NUMBER,
5646: p_document_type IN VARCHAR2,
5647: p_doc_subtype IN VARCHAR2,
5648: p_user_id IN po_lines.last_updated_by%TYPE,
5649: p_login_id IN po_lines.last_update_login%TYPE,
5650: x_return_status OUT NOCOPY VARCHAR2,
5651: x_msg_data OUT NOCOPY VARCHAR2)
5652:
5653: IS

Line 5786: p_user_id IN po_lines.last_updated_by%TYPE,

5782: p_api_version IN NUMBER,
5783: p_init_msg_list IN VARCHAR2,
5784: p_da_call_rec IN OUT NOCOPY po_document_action_pvt.DOC_ACTION_CALL_TBL_REC_TYPE,
5785: p_key IN po_session_gt.key%TYPE,
5786: p_user_id IN po_lines.last_updated_by%TYPE,
5787: p_login_id IN po_lines.last_update_login%TYPE,
5788: p_po_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE,
5789: p_req_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE,
5790: x_return_status OUT NOCOPY VARCHAR2,

Line 5787: p_login_id IN po_lines.last_update_login%TYPE,

5783: p_init_msg_list IN VARCHAR2,
5784: p_da_call_rec IN OUT NOCOPY po_document_action_pvt.DOC_ACTION_CALL_TBL_REC_TYPE,
5785: p_key IN po_session_gt.key%TYPE,
5786: p_user_id IN po_lines.last_updated_by%TYPE,
5787: p_login_id IN po_lines.last_update_login%TYPE,
5788: p_po_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE,
5789: p_req_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE,
5790: x_return_status OUT NOCOPY VARCHAR2,
5791: x_msg_data OUT NOCOPY VARCHAR2)

Line 6326: l_user_id po_lines.last_updated_by%TYPE := -1;

6322: d_module CONSTANT VARCHAR2(100) := g_module_prefix|| d_api_name;
6323:
6324: l_progress VARCHAR2(3) := '000' ;
6325: l_key po_session_gt.key%TYPE;
6326: l_user_id po_lines.last_updated_by%TYPE := -1;
6327: l_login_id po_lines.last_update_login%TYPE := -1;
6328: l_po_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE;
6329: l_req_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE;
6330:

Line 6327: l_login_id po_lines.last_update_login%TYPE := -1;

6323:
6324: l_progress VARCHAR2(3) := '000' ;
6325: l_key po_session_gt.key%TYPE;
6326: l_user_id po_lines.last_updated_by%TYPE := -1;
6327: l_login_id po_lines.last_update_login%TYPE := -1;
6328: l_po_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE;
6329: l_req_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE;
6330:
6331: BEGIN

Line 6708: -- Updates the Quanity/Amount Cancelled columns of Po lines/Shipments

6704: --Name: calculate_qty_cancel
6705:
6706: --Function:
6707: --
6708: -- Updates the Quanity/Amount Cancelled columns of Po lines/Shipments
6709: -- and Distributions
6710: -- The routine will be called from "Finally Close action"
6711: --
6712: --Parameters:

Line 6754: l_user_id po_lines.last_updated_by%TYPE := -1;

6750: d_module CONSTANT VARCHAR2(100) := g_module_prefix||d_api_name;
6751:
6752: l_progress VARCHAR2(3) := '000' ;
6753: l_line_loc_tbl po_tbl_NUMBER;
6754: l_user_id po_lines.last_updated_by%TYPE := -1;
6755: l_login_id po_lines.last_update_login%TYPE := -1;
6756:
6757:
6758:

Line 6755: l_login_id po_lines.last_update_login%TYPE := -1;

6751:
6752: l_progress VARCHAR2(3) := '000' ;
6753: l_line_loc_tbl po_tbl_NUMBER;
6754: l_user_id po_lines.last_updated_by%TYPE := -1;
6755: l_login_id po_lines.last_update_login%TYPE := -1;
6756:
6757:
6758:
6759: CURSOR l_ship_cursor(

Line 6902: UPDATE po_lines pol

6898: END IF;
6899:
6900: l_progress := '005' ;
6901:
6902: UPDATE po_lines pol
6903: SET pol.last_update_date = p_action_date,
6904: pol.last_updated_by = l_user_id,
6905: pol.last_update_login = l_login_id,
6906: pol.quantity =

Line 6936: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated in PO Lines table', SQL%ROWCOUNT);

6932: WHERE line_location_id=l_line_loc_tbl(i)
6933: AND shipment_type IN ('STANDARD','PLANNED'));
6934:
6935: IF g_debug_stmt THEN
6936: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated in PO Lines table', SQL%ROWCOUNT);
6937: END IF;
6938:
6939:
6940: END LOOP;