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_REQ_LINES_SV dependencies on PO_TBL_NUMBER

Line 697: l_deleted_line_list PO_TBL_NUMBER;

693:
694: x_progress VARCHAR2(3) := NULL;
695:
696: l_is_clm_document VARCHAR2(1);
697: l_deleted_line_list PO_TBL_NUMBER;
698: l_deleted_dist_list PO_TBL_NUMBER;
699:
700:
701: --

Line 698: l_deleted_dist_list PO_TBL_NUMBER;

694: x_progress VARCHAR2(3) := NULL;
695:
696: l_is_clm_document VARCHAR2(1);
697: l_deleted_line_list PO_TBL_NUMBER;
698: l_deleted_dist_list PO_TBL_NUMBER;
699:
700:
701: --
702: l_po_header_id PO_TBL_NUMBER;

Line 702: l_po_header_id PO_TBL_NUMBER;

698: l_deleted_dist_list PO_TBL_NUMBER;
699:
700:
701: --
702: l_po_header_id PO_TBL_NUMBER;
703: l_po_release_id PO_TBL_NUMBER;
704: l_po_line_id PO_TBL_NUMBER;
705: l_line_location_id PO_TBL_NUMBER;
706: L_req_header_id PO_TBL_NUMBER;

Line 703: l_po_release_id PO_TBL_NUMBER;

699:
700:
701: --
702: l_po_header_id PO_TBL_NUMBER;
703: l_po_release_id PO_TBL_NUMBER;
704: l_po_line_id PO_TBL_NUMBER;
705: l_line_location_id PO_TBL_NUMBER;
706: L_req_header_id PO_TBL_NUMBER;
707: l_req_line_id PO_TBL_NUMBER;

Line 704: l_po_line_id PO_TBL_NUMBER;

700:
701: --
702: l_po_header_id PO_TBL_NUMBER;
703: l_po_release_id PO_TBL_NUMBER;
704: l_po_line_id PO_TBL_NUMBER;
705: l_line_location_id PO_TBL_NUMBER;
706: L_req_header_id PO_TBL_NUMBER;
707: l_req_line_id PO_TBL_NUMBER;
708: l_linked_req_line_id PO_TBL_NUMBER;

Line 705: l_line_location_id PO_TBL_NUMBER;

701: --
702: l_po_header_id PO_TBL_NUMBER;
703: l_po_release_id PO_TBL_NUMBER;
704: l_po_line_id PO_TBL_NUMBER;
705: l_line_location_id PO_TBL_NUMBER;
706: L_req_header_id PO_TBL_NUMBER;
707: l_req_line_id PO_TBL_NUMBER;
708: l_linked_req_line_id PO_TBL_NUMBER;
709: l_req_dist_id PO_TBL_NUMBER;

Line 706: L_req_header_id PO_TBL_NUMBER;

702: l_po_header_id PO_TBL_NUMBER;
703: l_po_release_id PO_TBL_NUMBER;
704: l_po_line_id PO_TBL_NUMBER;
705: l_line_location_id PO_TBL_NUMBER;
706: L_req_header_id PO_TBL_NUMBER;
707: l_req_line_id PO_TBL_NUMBER;
708: l_linked_req_line_id PO_TBL_NUMBER;
709: l_req_dist_id PO_TBL_NUMBER;
710: l_return_status VARCHAR2(30);

Line 707: l_req_line_id PO_TBL_NUMBER;

703: l_po_release_id PO_TBL_NUMBER;
704: l_po_line_id PO_TBL_NUMBER;
705: l_line_location_id PO_TBL_NUMBER;
706: L_req_header_id PO_TBL_NUMBER;
707: l_req_line_id PO_TBL_NUMBER;
708: l_linked_req_line_id PO_TBL_NUMBER;
709: l_req_dist_id PO_TBL_NUMBER;
710: l_return_status VARCHAR2(30);
711: l_msg_data VARCHAR2(3000);

Line 708: l_linked_req_line_id PO_TBL_NUMBER;

704: l_po_line_id PO_TBL_NUMBER;
705: l_line_location_id PO_TBL_NUMBER;
706: L_req_header_id PO_TBL_NUMBER;
707: l_req_line_id PO_TBL_NUMBER;
708: l_linked_req_line_id PO_TBL_NUMBER;
709: l_req_dist_id PO_TBL_NUMBER;
710: l_return_status VARCHAR2(30);
711: l_msg_data VARCHAR2(3000);
712: l_msg_count NUMBER;

Line 709: l_req_dist_id PO_TBL_NUMBER;

705: l_line_location_id PO_TBL_NUMBER;
706: L_req_header_id PO_TBL_NUMBER;
707: l_req_line_id PO_TBL_NUMBER;
708: l_linked_req_line_id PO_TBL_NUMBER;
709: l_req_dist_id PO_TBL_NUMBER;
710: l_return_status VARCHAR2(30);
711: l_msg_data VARCHAR2(3000);
712: l_msg_count NUMBER;
713: l_api_name CONSTANT VARCHAR(60) := 'po.plsql.PO_REQ_LINES_SV.REMOVE_REQ_FROM_PO';

Line 1507: X_entity_id IN PO_TBL_NUMBER,

1503:
1504:
1505: ===========================================================================*/
1506: PROCEDURE update_req_for_linked_po_count(
1507: X_entity_id IN PO_TBL_NUMBER,
1508: X_entity IN VARCHAR2)
1509: IS
1510:
1511: l_unlinked_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;

Line 1511: l_unlinked_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;

1507: X_entity_id IN PO_TBL_NUMBER,
1508: X_entity IN VARCHAR2)
1509: IS
1510:
1511: l_unlinked_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1512: l_unlinked_po_count PO_TBL_NUMBER := PO_TBL_NUMBER();
1513: l_eligible_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1514: l_eligible_po_line_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1515: l_eligible_group_line_id PO_TBL_NUMBER := PO_TBL_NUMBER() ;

Line 1512: l_unlinked_po_count PO_TBL_NUMBER := PO_TBL_NUMBER();

1508: X_entity IN VARCHAR2)
1509: IS
1510:
1511: l_unlinked_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1512: l_unlinked_po_count PO_TBL_NUMBER := PO_TBL_NUMBER();
1513: l_eligible_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1514: l_eligible_po_line_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1515: l_eligible_group_line_id PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1516: l_eligible_clm_info_flag PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1() ;

Line 1513: l_eligible_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;

1509: IS
1510:
1511: l_unlinked_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1512: l_unlinked_po_count PO_TBL_NUMBER := PO_TBL_NUMBER();
1513: l_eligible_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1514: l_eligible_po_line_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1515: l_eligible_group_line_id PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1516: l_eligible_clm_info_flag PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1() ;
1517: l_eligible_option_indicator PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1() ;

Line 1514: l_eligible_po_line_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;

1510:
1511: l_unlinked_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1512: l_unlinked_po_count PO_TBL_NUMBER := PO_TBL_NUMBER();
1513: l_eligible_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1514: l_eligible_po_line_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1515: l_eligible_group_line_id PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1516: l_eligible_clm_info_flag PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1() ;
1517: l_eligible_option_indicator PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1() ;
1518: l_eligible_clm_base_line_num PO_TBL_NUMBER := PO_TBL_NUMBER() ;

Line 1515: l_eligible_group_line_id PO_TBL_NUMBER := PO_TBL_NUMBER() ;

1511: l_unlinked_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1512: l_unlinked_po_count PO_TBL_NUMBER := PO_TBL_NUMBER();
1513: l_eligible_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1514: l_eligible_po_line_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1515: l_eligible_group_line_id PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1516: l_eligible_clm_info_flag PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1() ;
1517: l_eligible_option_indicator PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1() ;
1518: l_eligible_clm_base_line_num PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1519: l_pclin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;

Line 1518: l_eligible_clm_base_line_num PO_TBL_NUMBER := PO_TBL_NUMBER() ;

1514: l_eligible_po_line_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1515: l_eligible_group_line_id PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1516: l_eligible_clm_info_flag PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1() ;
1517: l_eligible_option_indicator PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1() ;
1518: l_eligible_clm_base_line_num PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1519: l_pclin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1520:
1521: l_info_funded_slin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1522: l_info_funded_slin_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;

Line 1519: l_pclin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;

1515: l_eligible_group_line_id PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1516: l_eligible_clm_info_flag PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1() ;
1517: l_eligible_option_indicator PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1() ;
1518: l_eligible_clm_base_line_num PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1519: l_pclin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1520:
1521: l_info_funded_slin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1522: l_info_funded_slin_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1523:

Line 1521: l_info_funded_slin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;

1517: l_eligible_option_indicator PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1() ;
1518: l_eligible_clm_base_line_num PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1519: l_pclin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1520:
1521: l_info_funded_slin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1522: l_info_funded_slin_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1523:
1524: l_non_infofunded_slin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1525: l_non_infofunded_slin_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;

Line 1522: l_info_funded_slin_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;

1518: l_eligible_clm_base_line_num PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1519: l_pclin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1520:
1521: l_info_funded_slin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1522: l_info_funded_slin_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1523:
1524: l_non_infofunded_slin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1525: l_non_infofunded_slin_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1526:

Line 1524: l_non_infofunded_slin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;

1520:
1521: l_info_funded_slin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1522: l_info_funded_slin_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1523:
1524: l_non_infofunded_slin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1525: l_non_infofunded_slin_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1526:
1527: l_infofunded_slin_grp_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1528: l_infofd_group_line_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;

Line 1525: l_non_infofunded_slin_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;

1521: l_info_funded_slin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1522: l_info_funded_slin_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1523:
1524: l_non_infofunded_slin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1525: l_non_infofunded_slin_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1526:
1527: l_infofunded_slin_grp_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1528: l_infofd_group_line_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1529:

Line 1527: l_infofunded_slin_grp_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;

1523:
1524: l_non_infofunded_slin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1525: l_non_infofunded_slin_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1526:
1527: l_infofunded_slin_grp_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1528: l_infofd_group_line_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1529:
1530:
1531: l_clm_document VARCHAR2(1);

Line 1528: l_infofd_group_line_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;

1524: l_non_infofunded_slin_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1525: l_non_infofunded_slin_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1526:
1527: l_infofunded_slin_grp_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1528: l_infofd_group_line_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1529:
1530:
1531: l_clm_document VARCHAR2(1);
1532:

Line 1895: (p_reqLine_ids IN PO_TBL_NUMBER,

1891:
1892: ===========================================================================*/
1893:
1894: PROCEDURE update_par_draft_line_status
1895: (p_reqLine_ids IN PO_TBL_NUMBER,
1896: p_reqHeader_ids IN PO_TBL_NUMBER
1897: )
1898: IS
1899: l_api_name CONSTANT VARCHAR(60) := 'po.plsql.PO_REQ_LINES_SV.update_par_draft_line_status';

Line 1896: p_reqHeader_ids IN PO_TBL_NUMBER

1892: ===========================================================================*/
1893:
1894: PROCEDURE update_par_draft_line_status
1895: (p_reqLine_ids IN PO_TBL_NUMBER,
1896: p_reqHeader_ids IN PO_TBL_NUMBER
1897: )
1898: IS
1899: l_api_name CONSTANT VARCHAR(60) := 'po.plsql.PO_REQ_LINES_SV.update_par_draft_line_status';
1900: x_progress VARCHAR2(3) := '000';

Line 1955: l_eligible_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;

1951:
1952: l_api_name CONSTANT VARCHAR(60) := 'po.plsql.PO_REQ_LINES_SV.UPDATE_REQS_IN_POOL_FLAG';
1953: x_progress VARCHAR2(3) := '000';
1954:
1955: l_eligible_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1956: l_eligible_reqHeader_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1957: l_structure_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1958: l_linked_po_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1959:

Line 1956: l_eligible_reqHeader_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;

1952: l_api_name CONSTANT VARCHAR(60) := 'po.plsql.PO_REQ_LINES_SV.UPDATE_REQS_IN_POOL_FLAG';
1953: x_progress VARCHAR2(3) := '000';
1954:
1955: l_eligible_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1956: l_eligible_reqHeader_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1957: l_structure_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1958: l_linked_po_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1959:
1960: l_update_req_pool VARCHAR2(1) := 'N';

Line 1957: l_structure_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;

1953: x_progress VARCHAR2(3) := '000';
1954:
1955: l_eligible_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1956: l_eligible_reqHeader_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1957: l_structure_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1958: l_linked_po_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1959:
1960: l_update_req_pool VARCHAR2(1) := 'N';
1961:

Line 1958: l_linked_po_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;

1954:
1955: l_eligible_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1956: l_eligible_reqHeader_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1957: l_structure_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1958: l_linked_po_count PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1959:
1960: l_update_req_pool VARCHAR2(1) := 'N';
1961:
1962: BEGIN

Line 2014: l_eligible_reqLine_ids := PO_TBL_NUMBER();

2010: END IF;
2011:
2012: END loop;
2013:
2014: l_eligible_reqLine_ids := PO_TBL_NUMBER();
2015: l_eligible_reqHeader_ids := PO_TBL_NUMBER();
2016:
2017: -- Collect the entire structure into table type, if that structure is eligible.
2018: -- Note: Delete can happen to PO lines, which are linked to 1 or more Clin-Slin structures

Line 2015: l_eligible_reqHeader_ids := PO_TBL_NUMBER();

2011:
2012: END loop;
2013:
2014: l_eligible_reqLine_ids := PO_TBL_NUMBER();
2015: l_eligible_reqHeader_ids := PO_TBL_NUMBER();
2016:
2017: -- Collect the entire structure into table type, if that structure is eligible.
2018: -- Note: Delete can happen to PO lines, which are linked to 1 or more Clin-Slin structures
2019: -- and structure Id(Num10) will identify the unique structure.