DBA Data[Home] [Help]

APPS.GML_PO_GLDIST dependencies on PO_DISTRIBUTIONS_ALL

Line 1980: * po_distributions_all table with the correct accounts combination id

1976: * SYNOPSIS
1977: * proc update_accounts_orcl
1978: * RETURNS
1979: * This procedure will update the ORacle Fianancial table
1980: * po_distributions_all table with the correct accounts combination id
1981: * for Purchase Price Varaince (PPV ) and Accrued Accounts Payable(AAP)
1982: * GLOBAL VARIABLES
1983: *
1984: *

Line 2032: po_distributions_all pod,

2028: cpg_oragems_mapping map,
2029: gl_accu_mst acu,
2030: gl_acct_mst act,
2031: po_dist_dtl pdd,
2032: po_distributions_all pod,
2033: gl_plcy_mst gpm,
2034: gl_sets_of_books gsob
2035: WHERE map.po_id = v_po_id
2036: AND map.line_id = v_line_id

Line 2071: update po_distributions_all

2067: IF Cur_get_std_poinf%FOUND THEN
2068:
2069: if p_acct_ttl_num = 6100
2070: then
2071: update po_distributions_all
2072: set variance_account_id = x_combination_id
2073: where po_header_id = v_po_header_id
2074: and po_line_id = v_po_line_id
2075: and line_location_id = v_po_line_location_id;

Line 2080: update po_distributions_all

2076: end if;
2077:
2078: if p_acct_ttl_num = 3100
2079: then
2080: update po_distributions_all
2081: set accrual_account_id = x_combination_id
2082: where po_header_id = v_po_header_id
2083: and po_line_id = v_po_line_id
2084: and line_location_id = v_po_line_location_id;

Line 2101: update po_distributions_all

2097:
2098: IF Cur_get_blk_poinf%FOUND THEN
2099: if p_acct_ttl_num = 6100
2100: then
2101: update po_distributions_all
2102: set variance_account_id = x_combination_id
2103: where po_header_id = v_po_header_id
2104: and po_line_id = v_po_line_id
2105: and line_location_id = v_po_line_location_id

Line 2111: update po_distributions_all

2107: end if;
2108:
2109: if p_acct_ttl_num = 3100
2110: then
2111: update po_distributions_all
2112: set accrual_account_id = x_combination_id
2113: where po_header_id = v_po_header_id
2114: and po_line_id = v_po_line_id
2115: and line_location_id = v_po_line_location_id

Line 2137: update po_distributions_all

2133:
2134: IF Cur_get_pln_poinf%FOUND THEN
2135: if p_acct_ttl_num = 6100
2136: then
2137: update po_distributions_all
2138: set variance_account_id = x_combination_id
2139: where po_header_id = v_po_header_id
2140: and po_line_id = v_po_line_id
2141: and line_location_id = v_po_line_location_id

Line 2147: update po_distributions_all

2143: end if;
2144:
2145: if p_acct_ttl_num = 3100
2146: then
2147: update po_distributions_all
2148: set accrual_account_id = x_combination_id
2149: where po_header_id = v_po_header_id
2150: and po_line_id = v_po_line_id
2151: and line_location_id = v_po_line_location_id