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_CONTROL_ACTION_VALIDATIONS dependencies on PO_ONLINE_REPORT_TEXT

Line 165: INSERT INTO PO_ONLINE_REPORT_TEXT

161: -- shipmentid in case of document type= PO/Releases and subtype=Planned/
162: -- Standard at any entity level
163: -- Lineid in case of BPA and GBPA at any entity level
164: -- Headerid in case of CPA
165: INSERT INTO PO_ONLINE_REPORT_TEXT
166: (ONLINE_REPORT_ID,
167: LAST_UPDATE_LOGIN,
168: LAST_UPDATED_BY,
169: LAST_UPDATE_DATE,

Line 327: INSERT INTO PO_ONLINE_REPORT_TEXT(

323: -- subtype= Planned/Standard at any entity level
324: -- Lineid in case of BPA and GBPA at any entity level
325: -- Headerid in case of CPA
326:
327: INSERT INTO PO_ONLINE_REPORT_TEXT(
328: ONLINE_REPORT_ID,
329: LAST_UPDATE_LOGIN,
330: LAST_UPDATED_BY,
331: LAST_UPDATE_DATE,

Line 486: INSERT INTO PO_ONLINE_REPORT_TEXT(

482: -- subtype= Planned/Standard at any entity level
483: -- Lineid in case of BPA and GBPA at any entity level
484: -- Headerid in case of CPA
485:
486: INSERT INTO PO_ONLINE_REPORT_TEXT(
487: ONLINE_REPORT_ID,
488: LAST_UPDATE_LOGIN,
489: LAST_UPDATED_BY,
490: LAST_UPDATE_DATE,

Line 692: INSERT INTO PO_ONLINE_REPORT_TEXT(

688: -- subtype= Planned/Standard at any entity level
689: -- Lineid in case of BPA and GBPA at any entity level
690: -- Headerid in case of CPA
691:
692: INSERT INTO PO_ONLINE_REPORT_TEXT(
693: ONLINE_REPORT_ID,
694: LAST_UPDATE_LOGIN,
695: LAST_UPDATED_BY,
696: LAST_UPDATE_DATE,

Line 861: INSERT INTO PO_ONLINE_REPORT_TEXT(

857: -- Headerid in case of CPA
858:
859:
860:
861: INSERT INTO PO_ONLINE_REPORT_TEXT(
862: ONLINE_REPORT_ID,
863: LAST_UPDATE_LOGIN,
864: LAST_UPDATED_BY,
865: LAST_UPDATE_DATE,

Line 1051: INSERT INTO PO_ONLINE_REPORT_TEXT(

1047: -- Headerid in case of CPA
1048:
1049:
1050:
1051: INSERT INTO PO_ONLINE_REPORT_TEXT(
1052: ONLINE_REPORT_ID,
1053: LAST_UPDATE_LOGIN,
1054: LAST_UPDATED_BY,
1055: LAST_UPDATE_DATE,

Line 1219: INSERT INTO PO_ONLINE_REPORT_TEXT(

1215: -- subtype= Planned/Standard at any entity level
1216: -- Lineid in case of BPA and GBPA at any entity level
1217: -- Headerid in case of CPA
1218:
1219: INSERT INTO PO_ONLINE_REPORT_TEXT(
1220: ONLINE_REPORT_ID,
1221: LAST_UPDATE_LOGIN,
1222: LAST_UPDATED_BY,
1223: LAST_UPDATE_DATE,

Line 1394: INSERT INTO PO_ONLINE_REPORT_TEXT(

1390: --Bug15869000 : At the distribution level, quantity delivered can be
1391: --equal to the quantity ordered for cancel to go through (If it clears
1392: --all the other checks wrt line and shipment level). So removed the '='
1393: --condition while doing quantity checks at the distributions level.
1394: INSERT INTO PO_ONLINE_REPORT_TEXT(
1395: ONLINE_REPORT_ID,
1396: LAST_UPDATE_LOGIN,
1397: LAST_UPDATED_BY,
1398: LAST_UPDATE_DATE,

Line 1572: INSERT INTO PO_ONLINE_REPORT_TEXT(

1568: --Bug15869000 : At the distribution level, quantity billed can be
1569: --equal to the quantity ordered for cancel to go through (If it clears
1570: --all the other checks wrt line and shipment level). So removed the '='
1571: --condition while doing quantity checks at the distributions level.
1572: INSERT INTO PO_ONLINE_REPORT_TEXT(
1573: ONLINE_REPORT_ID,
1574: LAST_UPDATE_LOGIN,
1575: LAST_UPDATED_BY,
1576: LAST_UPDATE_DATE,

Line 1773: INSERT INTO PO_ONLINE_REPORT_TEXT(

1769: -- Lineid in case of BPA and GBPA at any entity level
1770: -- Headerid in case of CPA
1771:
1772:
1773: INSERT INTO PO_ONLINE_REPORT_TEXT(
1774: ONLINE_REPORT_ID,
1775: LAST_UPDATE_LOGIN,
1776: LAST_UPDATED_BY,
1777: LAST_UPDATE_DATE,

Line 1969: INSERT INTO PO_ONLINE_REPORT_TEXT(

1965: -- Lineid in case of BPA and GBPA at any entity level
1966: -- Headerid in case of CPA
1967:
1968:
1969: INSERT INTO PO_ONLINE_REPORT_TEXT(
1970: ONLINE_REPORT_ID,
1971: LAST_UPDATE_LOGIN,
1972: LAST_UPDATED_BY,
1973: LAST_UPDATE_DATE,

Line 2168: INSERT INTO po_online_report_text(

2164: -- Lineid in case of BPA and GBPA at any entity level
2165: -- Headerid in case of CPA
2166:
2167:
2168: INSERT INTO po_online_report_text(
2169: ONLINE_REPORT_ID,
2170: LAST_UPDATE_LOGIN,
2171: LAST_UPDATED_BY,
2172: LAST_UPDATE_DATE,

Line 2337: INSERT INTO po_online_report_text(

2333: -- Lineid in case of BPA and GBPA at any entity level
2334: -- Headerid in case of CPA
2335:
2336:
2337: INSERT INTO po_online_report_text(
2338: ONLINE_REPORT_ID,
2339: LAST_UPDATE_LOGIN,
2340: LAST_UPDATED_BY,
2341: LAST_UPDATE_DATE,

Line 2494: INSERT INTO po_online_report_text(

2490: -- Lineid in case of BPA and GBPA at any entity level
2491: -- Headerid in case of CPA
2492:
2493:
2494: INSERT INTO po_online_report_text(
2495: ONLINE_REPORT_ID,
2496: LAST_UPDATE_LOGIN,
2497: LAST_UPDATED_BY,
2498: LAST_UPDATE_DATE,

Line 2658: INSERT INTO po_online_report_text(

2654: --Bug 15913701. p_action_date is already a date variable.
2655: --Wrapping this inside to_date is giving unexpected results and query is
2656: --unnecessarily inserting values. Removed the to_date wrap around p_action_date.
2657:
2658: INSERT INTO po_online_report_text(
2659: ONLINE_REPORT_ID,
2660: LAST_UPDATE_LOGIN,
2661: LAST_UPDATED_BY,
2662: LAST_UPDATE_DATE,

Line 2826: INSERT INTO po_online_report_text(

2822: --Bug 15913701. p_action_date is already a date variable.
2823: --Wrapping this inside to_date is giving unexpected results and query is
2824: --unnecessarily inserting values. Removed the to_date wrap around p_action_date.
2825:
2826: INSERT INTO po_online_report_text(
2827: ONLINE_REPORT_ID,
2828: LAST_UPDATE_LOGIN,
2829: LAST_UPDATED_BY,
2830: LAST_UPDATE_DATE,

Line 2988: INSERT INTO po_online_report_text(

2984: -- Lineid in case of BPA and GBPA at any entity level
2985: -- Headerid in case of CPA
2986:
2987:
2988: INSERT INTO po_online_report_text(
2989: ONLINE_REPORT_ID,
2990: LAST_UPDATE_LOGIN,
2991: LAST_UPDATED_BY,
2992: LAST_UPDATE_DATE,

Line 3146: INSERT INTO po_online_report_text(

3142:
3143: -- Bug 16174863: Add condition in the select statement for
3144: -- po_pa_WITH_OPEN_REL_chk() to restrict the document type as BPA or planned PO.
3145:
3146: INSERT INTO po_online_report_text(
3147: ONLINE_REPORT_ID,
3148: LAST_UPDATE_LOGIN,
3149: LAST_UPDATED_BY,
3150: LAST_UPDATE_DATE,

Line 3202: INSERT INTO po_online_report_text(

3198: AND nvl(POR.closed_code,'OPEN') <> 'FINALLY CLOSED')
3199: );
3200: -- bug 16525950: seperately validate for Planned PO
3201: -- as index_num1 is Shipment id in this case
3202: INSERT INTO po_online_report_text(
3203: ONLINE_REPORT_ID,
3204: LAST_UPDATE_LOGIN,
3205: LAST_UPDATED_BY,
3206: LAST_UPDATE_DATE,

Line 3365: INSERT INTO po_online_report_text(

3361: -- Lineid in case of BPA and GBPA at any entity level
3362: -- Headerid in case of CPA
3363:
3364:
3365: INSERT INTO po_online_report_text(
3366: ONLINE_REPORT_ID,
3367: LAST_UPDATE_LOGIN,
3368: LAST_UPDATED_BY,
3369: LAST_UPDATE_DATE,

Line 3807: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

3803: p_online_report_id IN NUMBER,
3804: p_action_date IN DATE,
3805: p_login_id IN po_lines.last_update_login%TYPE,
3806: p_user_id IN po_lines.last_updated_by%TYPE,
3807: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
3808: p_key IN po_session_gt.key%TYPE,
3809: x_return_status OUT NOCOPY VARCHAR2,
3810: x_msg_data OUT NOCOPY VARCHAR2)
3811:

Line 4206: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

4202: p_action_date IN DATE,
4203: p_key IN po_session_gt.key%TYPE,
4204: p_login_id IN po_lines.last_update_login%TYPE,
4205: p_user_id IN po_lines.last_updated_by%TYPE,
4206: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
4207: p_online_report_id IN NUMBER,
4208: x_return_status OUT NOCOPY VARCHAR2,
4209: x_return_msg OUT NOCOPY VARCHAR2)
4210: IS

Line 4422: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

4418: p_online_report_id IN NUMBER,
4419: p_key IN po_session_gt.key%TYPE,
4420: p_user_id IN po_lines.last_updated_by%TYPE,
4421: p_login_id IN po_lines.last_update_login%TYPE,
4422: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
4423: p_agent_id IN PO_HEADERS.agent_id%TYPE,
4424: x_return_status OUT NOCOPY VARCHAR2,
4425: x_return_msg OUT NOCOPY VARCHAR2)
4426:

Line 4455: INSERT INTO PO_online_report_text(

4451:
4452: l_progress :='001';
4453:
4454: -- Validate agent security for SPO/PPO/BPA/CPA
4455: INSERT INTO PO_online_report_text(
4456: ONLINE_REPORT_ID,
4457: LAST_UPDATE_LOGIN,
4458: LAST_UPDATED_BY,
4459: LAST_UPDATE_DATE,

Line 4508: INSERT INTO PO_online_report_text(

4504:
4505:
4506: -- Validate agent security for Releases
4507:
4508: INSERT INTO PO_online_report_text(
4509: ONLINE_REPORT_ID,
4510: LAST_UPDATE_LOGIN,
4511: LAST_UPDATED_BY,
4512: LAST_UPDATE_DATE,

Line 4624: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

4620: p_online_report_id IN NUMBER,
4621: p_agent_id IN PO_HEADERS.agent_id%TYPE,
4622: p_user_id IN po_lines.last_updated_by%TYPE,
4623: p_login_id IN po_lines.last_update_login%TYPE,
4624: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
4625: p_source IN VARCHAR2 DEFAULT NULL,
4626: p_key IN po_session_gt.key%TYPE,
4627: x_return_status OUT NOCOPY VARCHAR2,
4628: x_return_msg OUT NOCOPY VARCHAR2)

Line 4808: INSERT INTO po_online_report_text(

4804: l_progress :='009';
4805: -- If not in the set, insert error
4806: IF NOT l_action_ok THEN
4807:
4808: INSERT INTO po_online_report_text(
4809: ONLINE_REPORT_ID,
4810: LAST_UPDATE_LOGIN,
4811: LAST_UPDATED_BY,
4812: LAST_UPDATE_DATE,

Line 4942: l_sequence po_online_report_text.sequence%TYPE;

4938:
4939: l_progress VARCHAR2(3) := '000' ;
4940: l_line_loc_id_tbl po_tbl_number;
4941: l_line_id_tbl po_tbl_number;
4942: l_sequence po_online_report_text.sequence%TYPE;
4943: l_line_token VARCHAR2(20);
4944: l_ship_token VARCHAR2(20);
4945: l_amt_token VARCHAR2(20);
4946: l_qty_token VARCHAR2(20);

Line 4987: FROM PO_ONLINE_REPORT_TEXT

4983: IF p_revert_chg_flag ='Y' THEN
4984:
4985: SELECT Nvl(Max(sequence) ,0)
4986: INTO l_sequence
4987: FROM PO_ONLINE_REPORT_TEXT
4988: WHERE online_report_id=p_online_report_id;
4989:
4990: IF g_debug_stmt THEN
4991: PO_DEBUG.debug_var(d_module,l_progress,'l_sequence',l_sequence);

Line 5132: INSERT INTO PO_ONLINE_REPORT_TEXT(

5128: -- Lineid in case of BPA and GBPA at any entity level
5129: -- Headerid in case of CPA
5130:
5131:
5132: INSERT INTO PO_ONLINE_REPORT_TEXT(
5133: ONLINE_REPORT_ID,
5134: LAST_UPDATE_LOGIN,
5135: LAST_UPDATED_BY,
5136: LAST_UPDATE_DATE,

Line 5285: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

5281: p_revert_chg_flag IN VARCHAR2,
5282: p_online_report_id IN NUMBER,
5283: p_user_id IN po_lines.last_updated_by%TYPE,
5284: p_login_id IN po_lines.last_update_login%TYPE,
5285: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
5286: p_source IN VARCHAR2 DEFAULT NULL,
5287: p_low_level_key IN po_session_gt.key%TYPE,
5288: p_entity_level_key IN po_session_gt.key%TYPE,
5289: p_po_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE,

Line 5324: INSERT INTO PO_ONLINE_REPORT_TEXT(

5320:
5321:
5322: IF p_revert_chg_flag ='Y' THEN
5323:
5324: INSERT INTO PO_ONLINE_REPORT_TEXT(
5325: ONLINE_REPORT_ID,
5326: LAST_UPDATE_LOGIN,
5327: LAST_UPDATED_BY,
5328: LAST_UPDATE_DATE,

Line 5424: INSERT INTO PO_ONLINE_REPORT_TEXT(

5420: -- Lineid in case of BPA and GBPA at any entity level
5421: -- Headerid in case of CPA
5422:
5423:
5424: INSERT INTO PO_ONLINE_REPORT_TEXT(
5425: ONLINE_REPORT_ID,
5426: LAST_UPDATE_LOGIN,
5427: LAST_UPDATED_BY,
5428: LAST_UPDATE_DATE,

Line 5589: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

5585: x_return_status OUT NOCOPY VARCHAR2,
5586: x_msg_data OUT NOCOPY VARCHAR2,
5587: p_user_id IN po_lines.last_updated_by%TYPE,
5588: p_login_id IN po_lines.last_update_login%TYPE,
5589: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
5590: x_cancel_reqs_flag IN OUT NOCOPY VARCHAR2,
5591: p_online_report_id IN NUMBER,
5592: p_doc_type IN VARCHAR2,
5593: p_doc_id IN NUMBER,

Line 5658: INSERT INTO po_online_report_text(

5654: PO_DEBUG.debug_var(d_module,l_progress,'x_cancel_reqs_flag',x_cancel_reqs_flag);
5655: END IF;
5656:
5657: IF l_show_warning AND x_cancel_reqs_flag IS NOT NULL THEN
5658: INSERT INTO po_online_report_text(
5659: ONLINE_REPORT_ID,
5660: LAST_UPDATE_LOGIN,
5661: LAST_UPDATED_BY,
5662: LAST_UPDATE_DATE,

Line 5786: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

5782: p_online_report_id IN NUMBER,
5783: p_key IN po_session_gt.key%TYPE,
5784: p_user_id IN po_lines.last_updated_by%TYPE,
5785: p_login_id IN po_lines.last_update_login%TYPE,
5786: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
5787: x_return_status OUT NOCOPY VARCHAR2,
5788: x_return_msg OUT NOCOPY VARCHAR2)
5789: IS
5790:

Line 5816: INSERT INTO PO_ONLINE_REPORT_TEXT(

5812:
5813: l_progress := '001';
5814:
5815: -- Validate doc_type and doc_subtype combination
5816: INSERT INTO PO_ONLINE_REPORT_TEXT(
5817: ONLINE_REPORT_ID,
5818: LAST_UPDATE_LOGIN,
5819: LAST_UPDATED_BY,
5820: LAST_UPDATE_DATE,

Line 5872: INSERT INTO PO_ONLINE_REPORT_TEXT(

5868: l_progress := '002';
5869:
5870: -- Validate : If the entity level is SHIPMENT,
5871: -- then the entity_id should a valid line_location_id in po_line_locations
5872: INSERT INTO PO_ONLINE_REPORT_TEXT(
5873: ONLINE_REPORT_ID,
5874: LAST_UPDATE_LOGIN,
5875: LAST_UPDATED_BY,
5876: LAST_UPDATE_DATE,

Line 5918: INSERT INTO PO_ONLINE_REPORT_TEXT(

5914: l_progress := '003';
5915:
5916: -- Validate : If the entity level is LINE,
5917: -- then the entity_id should a valid po_line_id in po_lines
5918: INSERT INTO PO_ONLINE_REPORT_TEXT(
5919: ONLINE_REPORT_ID,
5920: LAST_UPDATE_LOGIN,
5921: LAST_UPDATED_BY,
5922: LAST_UPDATE_DATE,

Line 5965: INSERT INTO PO_ONLINE_REPORT_TEXT(

5961: l_progress := '004';
5962:
5963: -- Validate : If the entity level is HEADER and docuemnt type is PO/PA,
5964: -- then the entity_id should a valid po_header_id in po_headers
5965: INSERT INTO PO_ONLINE_REPORT_TEXT(
5966: ONLINE_REPORT_ID,
5967: LAST_UPDATE_LOGIN,
5968: LAST_UPDATED_BY,
5969: LAST_UPDATE_DATE,

Line 6010: INSERT INTO PO_ONLINE_REPORT_TEXT(

6006: l_progress := '005';
6007:
6008: -- Validate : If the entity level is HEADER and docuemnt type is RELEASE,
6009: -- then the entity_id should a valid po_release_id in po_releases
6010: INSERT INTO PO_ONLINE_REPORT_TEXT(
6011: ONLINE_REPORT_ID,
6012: LAST_UPDATE_LOGIN,
6013: LAST_UPDATED_BY,
6014: LAST_UPDATE_DATE,

Line 6058: INSERT INTO PO_ONLINE_REPORT_TEXT(

6054:
6055: -- Validate :doc_id parametr should be a valid po_header_id in po_headers
6056: -- or valid po_release_id in po_releases
6057:
6058: INSERT INTO PO_ONLINE_REPORT_TEXT(
6059: ONLINE_REPORT_ID,
6060: LAST_UPDATE_LOGIN,
6061: LAST_UPDATED_BY,
6062: LAST_UPDATE_DATE,

Line 6135: INSERT INTO PO_ONLINE_REPORT_TEXT(

6131: ) ;
6132:
6133: IF l_org_count>1 THEN
6134:
6135: INSERT INTO PO_ONLINE_REPORT_TEXT(
6136: ONLINE_REPORT_ID,
6137: LAST_UPDATE_LOGIN,
6138: LAST_UPDATED_BY,
6139: LAST_UPDATE_DATE,

Line 6253: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

6249: p_user_id IN po_lines.last_updated_by%TYPE,
6250: p_login_id IN po_lines.last_update_login%TYPE,
6251: p_po_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE,
6252: p_req_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE,
6253: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
6254: x_return_status OUT NOCOPY VARCHAR2,
6255: x_return_msg OUT NOCOPY VARCHAR2)
6256:
6257:

Line 6386: INSERT INTO po_online_report_text(

6382:
6383: -- If the valdation fails then insert error into online report text
6384: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6385:
6386: INSERT INTO po_online_report_text(
6387: ONLINE_REPORT_ID,
6388: LAST_UPDATE_LOGIN,
6389: LAST_UPDATED_BY,
6390: LAST_UPDATE_DATE,

Line 6506: -- an entry in po_online_report_text table

6502: -- record which will be used to identify records eligible for futher
6503: -- processing
6504: --
6505: --Effects:1.Updates the process entity flag=N if for that entity id there is
6506: -- an entry in po_online_report_text table
6507: -- 2.Deletes the data from session gt table, which was used for validations
6508: --
6509:
6510: --Parameters:

Line 6565: -- If there is an entry in po_online_report_text for the entity_id and

6561:
6562:
6563: -- Upadate char5[column corresponding to process_entity_flag in entity record
6564: -- table] in po_session_gt to 'N'
6565: -- If there is an entry in po_online_report_text for the entity_id and
6566: -- entity_level combination
6567: -- Columns mapping :
6568: -- entity_id in entity record = num1 in session gt = transaction_id in
6569: -- po_online_report_text

Line 6569: -- po_online_report_text

6565: -- If there is an entry in po_online_report_text for the entity_id and
6566: -- entity_level combination
6567: -- Columns mapping :
6568: -- entity_id in entity record = num1 in session gt = transaction_id in
6569: -- po_online_report_text
6570: -- entity_level in entity record = char3 in session gt = transaction_type in
6571: -- po_online_report_text
6572: -- process_entity_flag in entity record char5 in session gt
6573:

Line 6571: -- po_online_report_text

6567: -- Columns mapping :
6568: -- entity_id in entity record = num1 in session gt = transaction_id in
6569: -- po_online_report_text
6570: -- entity_level in entity record = char3 in session gt = transaction_type in
6571: -- po_online_report_text
6572: -- process_entity_flag in entity record char5 in session gt
6573:
6574:
6575: UPDATE po_session_gt

Line 6579: FROM po_online_report_text

6575: UPDATE po_session_gt
6576: SET char5 ='N'
6577: WHERE KEY=p_key
6578: AND EXISTS(SELECT 'error record exists'
6579: FROM po_online_report_text
6580: WHERE transaction_id=num1
6581: AND transaction_type=char3
6582: AND Nvl(message_type,'E') = 'E'
6583: AND online_report_id =p_online_report_id);

Line 6728: l_sequence po_online_report_text.sequence%TYPE ;

6724:
6725:
6726:
6727: l_agent_id PO_HEADERS.agent_id%TYPE := FND_GLOBAL.employee_id;
6728: l_sequence po_online_report_text.sequence%TYPE ;
6729:
6730: d_api_name CONSTANT VARCHAR2(30) := 'validate_cancel_action';
6731: d_module CONSTANT VARCHAR2(100) := g_pkg_name || d_api_name;
6732: l_progress VARCHAR2(3) := '000' ;

Line 6757: SELECT PO_ONLINE_REPORT_TEXT_S.nextval

6753:
6754: l_progress := '001';
6755:
6756: --Get the unique id to be used for this document
6757: SELECT PO_ONLINE_REPORT_TEXT_S.nextval
6758: INTO l_online_report_id
6759: FROM sys.dual;
6760:
6761: