APPS.PO_RETROACTIVE_PRICING_PVT dependencies on PO_RETROPRICE_GT

Line 15: * table po_retroprice_gt.

11: TYPE char30_table is table of varchar2(30) index by binary_integer;
12: TYPE date_table is table of date index by binary_integer;
13:
14: /* Global tables that are defined for inserting into the global temp
15: * table po_retroprice_gt.
16: */
17: g_row_id_table char30_table;
18: g_exclude_row_id_table char30_table;
19: g_new_price_table num_table;

Line 531: FROM po_retroprice_gt

527: --
528:
529: cursor update_ship_price is
530: SELECT row_id, new_price
531: FROM po_retroprice_gt
532: WHERE po_release_id is not null;
533:
534: cursor update_line_price is
535: SELECT row_id, new_price

Line 536: FROM po_retroprice_gt

532: WHERE po_release_id is not null;
533:
534: cursor update_line_price is
535: SELECT row_id, new_price
536: FROM po_retroprice_gt
537: WHERE po_header_id is not null;
538:
539:
540: x_item_category_str varchar2(2000);

Line 1581: /* Insert the values in the temp table po_retroprice_gt

1577: --
1578:
1579: END IF; /* l_po_line_id_table(i) IS NOT NULL */
1580:
1581: /* Insert the values in the temp table po_retroprice_gt
1582: * for each Blanket Line that we process.
1583: */
1584: l_module := g_log_head||l_api_name||'.'||
1585: '090'||'.';

Line 1587: INSERT into po_retroprice_gt(

1583: */
1584: l_module := g_log_head||l_api_name||'.'||
1585: '090'||'.';
1586: FORALL insert_index in 1..g_row_id_table.COUNT
1587: INSERT into po_retroprice_gt(
1588: row_id,
1589: new_price,
1590: po_header_id,
1591: po_release_id,

Line 1950: FROM po_retroprice_gt prp

1946: BULK COLLECT INTO
1947: g_po_release_id_table,
1948: g_rel_auth_table,
1949: l_global_arch_rev_num_table
1950: FROM po_retroprice_gt prp
1951: WHERE prp.po_release_id is not null;
1952:
1953: --
1954: -- Calculate Tax for updated Releases

Line 2019: FROM po_retroprice_gt prp

2015: l_module := g_log_head||l_api_name||'.'||'020'||'.';
2016: SELECT row_id
2017: BULK COLLECT INTO
2018: l_row_id_table
2019: FROM po_retroprice_gt prp
2020: WHERE prp.po_release_id is not null
2021: and nvl(authorization_status,'INCOMPLETE') = 'APPROVED';
2022:
2023: l_module := g_log_head||l_api_name||'.'||'030'||'.';

Line 2098: FROM po_retroprice_gt prp

2094: BULK COLLECT INTO
2095: g_po_header_id_table,
2096: g_po_auth_table,
2097: l_global_arch_rev_num_table
2098: FROM po_retroprice_gt prp
2099: WHERE prp.po_header_id is not null;
2100:
2101: --
2102: -- Calculate Tax for updated Releases

Line 2165: FROM po_retroprice_gt prp

2161: l_module := g_log_head||l_api_name||'.'||'020'||'.';
2162: SELECT row_id
2163: BULK COLLECT INTO
2164: l_row_id_table
2165: FROM po_retroprice_gt prp
2166: WHERE prp.po_header_id is not null
2167: and nvl(authorization_status,'INCOMPLETE') = 'APPROVED';
2168:
2169: l_module := g_log_head||l_api_name||'.'||'030'||'.';

Line 2547: * Effects: Get the po_header_id from the global temp table po_retroprice_gt

2543: /**
2544: * Private Procedure: Launch_PO_Approval
2545: * Modifies: Authorization_status of po_headers if the document was
2546: * already approved.
2547: * Effects: Get the po_header_id from the global temp table po_retroprice_gt
2548: * which has all the document ids that have been updated with
2549: * new price. If the document is in the approved state, then
2550: * call submission_check and if it is successful, initiate
2551: * approval. This is called from massupdate_releases procedure.

Line 2682: * Effects: Get the po_release_id from the global temp table po_retroprice_gt

2678: /**
2679: * Private Procedure: Launch_REL_Approval
2680: * Modifies: Authorization_status of po_releases if the document was
2681: * already approved.
2682: * Effects: Get the po_release_id from the global temp table po_retroprice_gt
2683: * which has all the document ids that have been updated with
2684: * new price. If the document is in the approved state, then
2685: * call submission_check and if it is successful, initiate
2686: * approval. This is called from massupdate_releases procedure.