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.ARP_PROCESS_DET_PKG dependencies on AR_RECEIVABLE_APPS_GT

Line 70: | x_apps_rec Out variable containing the ar_receivable_apps_gt rec|

66: | p_charges_uediscounted Unearned Discount on charge |
67: | p_ps_rec Payment schedule invoice |
68: | p_ae_sys_rec Receivable system parameters |
69: | -- |
70: | x_apps_rec Out variable containing the ar_receivable_apps_gt rec|
71: +-----------------------------------------------------------------------------+
72: | Action : Compute payment schedule effect based on amount arguments |
73: | then update the global variable g_payschedule_rec |
74: | Return a record ar_receivable_apps_gt type with the amount info |

Line 74: | Return a record ar_receivable_apps_gt type with the amount info |

70: | x_apps_rec Out variable containing the ar_receivable_apps_gt rec|
71: +-----------------------------------------------------------------------------+
72: | Action : Compute payment schedule effect based on amount arguments |
73: | then update the global variable g_payschedule_rec |
74: | Return a record ar_receivable_apps_gt type with the amount info |
75: +-----------------------------------------------------------------------------*/
76: PROCEDURE upd_inv_ps(
77: p_app_level IN VARCHAR2,
78: --

Line 103: x_app_rec OUT NOCOPY ar_receivable_apps_gt%ROWTYPE,

99: p_freight_uediscounted IN NUMBER,
100: p_charges_uediscounted IN NUMBER,
101: p_ps_rec IN ar_payment_schedules%ROWTYPE,
102: --
103: x_app_rec OUT NOCOPY ar_receivable_apps_gt%ROWTYPE,
104: x_return_status IN OUT NOCOPY VARCHAR2);
105:
106: /*-----------------------------------------------------------------------------+
107: | Procedure insert_rapps_p |

Line 110: | p_app_rec variable of type ar_receivable_apps_gt |

106: /*-----------------------------------------------------------------------------+
107: | Procedure insert_rapps_p |
108: +-----------------------------------------------------------------------------+
109: | Parameter : |
110: | p_app_rec variable of type ar_receivable_apps_gt |
111: +-----------------------------------------------------------------------------+
112: | Action : insert p_rec_apps in ar_receivable_apps_gt |
113: +-----------------------------------------------------------------------------*/
114: PROCEDURE insert_rapps_p

Line 112: | Action : insert p_rec_apps in ar_receivable_apps_gt |

108: +-----------------------------------------------------------------------------+
109: | Parameter : |
110: | p_app_rec variable of type ar_receivable_apps_gt |
111: +-----------------------------------------------------------------------------+
112: | Action : insert p_rec_apps in ar_receivable_apps_gt |
113: +-----------------------------------------------------------------------------*/
114: PROCEDURE insert_rapps_p
115: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
116: x_return_status IN OUT NOCOPY VARCHAR2);

Line 115: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,

111: +-----------------------------------------------------------------------------+
112: | Action : insert p_rec_apps in ar_receivable_apps_gt |
113: +-----------------------------------------------------------------------------*/
114: PROCEDURE insert_rapps_p
115: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
116: x_return_status IN OUT NOCOPY VARCHAR2);
117:
118: /*-----------------------------------------------------------------------------+
119: | Procedure res_ctl_rem_amt_for_app |

Line 122: | p_app_rec variable of type ar_receivable_apps_gt |

118: /*-----------------------------------------------------------------------------+
119: | Procedure res_ctl_rem_amt_for_app |
120: +-----------------------------------------------------------------------------+
121: | Parameter : |
122: | p_app_rec variable of type ar_receivable_apps_gt |
123: +-----------------------------------------------------------------------------+
124: | Action : restore the amounts in the ra_customer_trx_lines_gt |
125: +-----------------------------------------------------------------------------*/
126: PROCEDURE res_ctl_rem_amt_for_app

Line 127: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,

123: +-----------------------------------------------------------------------------+
124: | Action : restore the amounts in the ra_customer_trx_lines_gt |
125: +-----------------------------------------------------------------------------*/
126: PROCEDURE res_ctl_rem_amt_for_app
127: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
128: x_return_status IN OUT NOCOPY VARCHAR2);
129:
130: /*-----------------------------------------------------------------------------+
131: | Procedure res_inv_ps |

Line 134: | p_app_rec variable of type ar_receivable_apps_gt |

130: /*-----------------------------------------------------------------------------+
131: | Procedure res_inv_ps |
132: +-----------------------------------------------------------------------------+
133: | Parameter : |
134: | p_app_rec variable of type ar_receivable_apps_gt |
135: +-----------------------------------------------------------------------------+
136: | Action : restore the amounts in the g_payschedule_trx based on the input|
137: +-----------------------------------------------------------------------------*/
138: PROCEDURE res_inv_ps

Line 139: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,

135: +-----------------------------------------------------------------------------+
136: | Action : restore the amounts in the g_payschedule_trx based on the input|
137: +-----------------------------------------------------------------------------*/
138: PROCEDURE res_inv_ps
139: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
140: x_return_status IN OUT NOCOPY VARCHAR2);
141:
142: /*-----------------------------------------------------------------------------+
143: | Procedure delete_application |

Line 146: | p_app_rec variable of type ar_receivable_apps_gt |

142: /*-----------------------------------------------------------------------------+
143: | Procedure delete_application |
144: +-----------------------------------------------------------------------------+
145: | Parameter : |
146: | p_app_rec variable of type ar_receivable_apps_gt |
147: +-----------------------------------------------------------------------------+
148: | Action : |
149: | 1) Call res_inv_ps to restore payment schedule |
150: | 2) Call res_ctl_rem_amt_for_app to restore the ra_customer_trx_lines_gt |

Line 152: | 3) Delete the record from ar_receivable_apps_gt |

148: | Action : |
149: | 1) Call res_inv_ps to restore payment schedule |
150: | 2) Call res_ctl_rem_amt_for_app to restore the ra_customer_trx_lines_gt |
151: | amounts |
152: | 3) Delete the record from ar_receivable_apps_gt |
153: +-----------------------------------------------------------------------------*/
154: PROCEDURE delete_application
155: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
156: x_return_status IN OUT NOCOPY VARCHAR2);

Line 155: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,

151: | amounts |
152: | 3) Delete the record from ar_receivable_apps_gt |
153: +-----------------------------------------------------------------------------*/
154: PROCEDURE delete_application
155: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
156: x_return_status IN OUT NOCOPY VARCHAR2);
157:
158: /*-----------------------------------------------------------------------------+
159: | Procedure do_apply |

Line 162: | p_app_rec variable of type ar_receivable_apps_gt |

158: /*-----------------------------------------------------------------------------+
159: | Procedure do_apply |
160: +-----------------------------------------------------------------------------+
161: | Parameter : |
162: | p_app_rec variable of type ar_receivable_apps_gt |
163: | p_customer_trx invoice record |
164: | p_ae_sys_rec receivable system parameter |
165: | p_gt_id global ID |
166: +-----------------------------------------------------------------------------+

Line 170: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,

166: +-----------------------------------------------------------------------------+
167: | Action : Call arp_det_dist_pkg to do the application |
168: +-----------------------------------------------------------------------------*/
169: PROCEDURE do_apply
170: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
171: p_gt_id IN VARCHAR2,
172: x_return_status IN OUT NOCOPY VARCHAR2);
173:
174: /*-----------------------------------------------------------------------------+

Line 239: | x_app_rec return the current ar_receivable_apps_gt record matching|

235: | p_app_level Application level TRANSACTION/GROUP/LINE |
236: | p_group_id Group_id required if level is GROUP |
237: | p_ctl_id customer_trx_line_id required if level is LINE |
238: | Out variable |
239: | x_app_rec return the current ar_receivable_apps_gt record matching|
240: | the search criteria in ar_receivable_apps_gt |
241: | Return : |
242: | Gt_id of that record matching the search criteria |
243: | If no row found the n returns NO_GT_ID |

Line 240: | the search criteria in ar_receivable_apps_gt |

236: | p_group_id Group_id required if level is GROUP |
237: | p_ctl_id customer_trx_line_id required if level is LINE |
238: | Out variable |
239: | x_app_rec return the current ar_receivable_apps_gt record matching|
240: | the search criteria in ar_receivable_apps_gt |
241: | Return : |
242: | Gt_id of that record matching the search criteria |
243: | If no row found the n returns NO_GT_ID |
244: +-----------------------------------------------------------------------------+

Line 246: | Search for the current ar_receivable_apps_gt record that match the criteria|

242: | Gt_id of that record matching the search criteria |
243: | If no row found the n returns NO_GT_ID |
244: +-----------------------------------------------------------------------------+
245: | Action : |
246: | Search for the current ar_receivable_apps_gt record that match the criteria|
247: +-----------------------------------------------------------------------------*/
248: FUNCTION cur_app_gt_id
249: ( p_app_level IN VARCHAR2,
250: --

Line 258: x_app_rec OUT NOCOPY ar_receivable_apps_gt%ROWTYPE)

254: p_source_data_key4 IN VARCHAR2,
255: p_source_data_key5 IN VARCHAR2,
256: --
257: p_ctl_id IN NUMBER,
258: x_app_rec OUT NOCOPY ar_receivable_apps_gt%ROWTYPE)
259: RETURN VARCHAR2;
260:
261:
262: PROCEDURE dump_payschedule(p_ps_rec IN ar_payment_schedules%ROWTYPE);

Line 722: | x_apps_rec Out variable containing the ar_receivable_apps_gt rec|

718: | p_charges_uediscounted Unearned Discount on charge |
719: | p_ps_rec Payment schedule invoice |
720: | p_ae_sys_rec Receivable system parameters |
721: | -- |
722: | x_apps_rec Out variable containing the ar_receivable_apps_gt rec|
723: +-----------------------------------------------------------------------------+
724: | Action : Compute payment schedule effect based on amount arguments |
725: | then update the global variable g_payschedule_rec |
726: | Return a record ar_receivable_apps_gt type with the amount info |

Line 726: | Return a record ar_receivable_apps_gt type with the amount info |

722: | x_apps_rec Out variable containing the ar_receivable_apps_gt rec|
723: +-----------------------------------------------------------------------------+
724: | Action : Compute payment schedule effect based on amount arguments |
725: | then update the global variable g_payschedule_rec |
726: | Return a record ar_receivable_apps_gt type with the amount info |
727: +-----------------------------------------------------------------------------*/
728: PROCEDURE upd_inv_ps(
729: p_app_level IN VARCHAR2,
730: --

Line 755: x_app_rec OUT NOCOPY ar_receivable_apps_gt%ROWTYPE,

751: p_freight_uediscounted IN NUMBER,
752: p_charges_uediscounted IN NUMBER,
753: p_ps_rec IN ar_payment_schedules%ROWTYPE,
754: --
755: x_app_rec OUT NOCOPY ar_receivable_apps_gt%ROWTYPE,
756: x_return_status IN OUT NOCOPY VARCHAR2)
757: IS
758: l_amount_applied NUMBER := 0;
759: l_discount_taken_total NUMBER:=0;

Line 788: l_apps_rec ar_receivable_apps_gt%ROWTYPE;

784: l_nocopy_acctd_amt_due_remain NUMBER;
785: l_applied_concern VARCHAR2(50);
786: l_earned_concern VARCHAR2(50);
787: l_uearned_concern VARCHAR2(50);
788: l_apps_rec ar_receivable_apps_gt%ROWTYPE;
789: l_gt_id VARCHAR2(30);
790: l_ps_rec ar_payment_schedules%ROWTYPE;
791: l_discount_taken_earned NUMBER := 0;
792: l_discount_taken_unearned NUMBER := 0;

Line 1106: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE)

1102:
1103:
1104:
1105: PROCEDURE disp_app_rec
1106: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE)
1107: IS
1108: BEGIN
1109: arp_standard.debug('p_app_rec.GT_ID :'||p_app_rec.GT_ID);
1110: arp_standard.debug('p_app_rec.app_level :'||p_app_rec.app_level);

Line 1155: | p_app_rec variable of type ar_receivable_apps_gt |

1151: /*-----------------------------------------------------------------------------+
1152: | Procedure insert_rapps_p |
1153: +-----------------------------------------------------------------------------+
1154: | Parameter : |
1155: | p_app_rec variable of type ar_receivable_apps_gt |
1156: +-----------------------------------------------------------------------------+
1157: | Action : insert p_rec_apps in ar_receivable_apps_gt |
1158: +-----------------------------------------------------------------------------*/
1159: PROCEDURE insert_rapps_p

Line 1157: | Action : insert p_rec_apps in ar_receivable_apps_gt |

1153: +-----------------------------------------------------------------------------+
1154: | Parameter : |
1155: | p_app_rec variable of type ar_receivable_apps_gt |
1156: +-----------------------------------------------------------------------------+
1157: | Action : insert p_rec_apps in ar_receivable_apps_gt |
1158: +-----------------------------------------------------------------------------*/
1159: PROCEDURE insert_rapps_p
1160: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1161: x_return_status IN OUT NOCOPY VARCHAR2)

Line 1160: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,

1156: +-----------------------------------------------------------------------------+
1157: | Action : insert p_rec_apps in ar_receivable_apps_gt |
1158: +-----------------------------------------------------------------------------*/
1159: PROCEDURE insert_rapps_p
1160: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1161: x_return_status IN OUT NOCOPY VARCHAR2)
1162: IS
1163: BEGIN
1164: arp_standard.debug('insert_rapps_p +');

Line 1166: INSERT INTO ar_receivable_apps_gt

1162: IS
1163: BEGIN
1164: arp_standard.debug('insert_rapps_p +');
1165: disp_app_rec(p_app_rec);
1166: INSERT INTO ar_receivable_apps_gt
1167: (GT_ID
1168: ,app_level
1169: ,source_data_key1
1170: ,source_data_key2

Line 1268: | p_app_rec variable of type ar_receivable_apps_gt |

1264: /*-----------------------------------------------------------------------------+
1265: | Procedure res_ctl_rem_amt_for_app |
1266: +-----------------------------------------------------------------------------+
1267: | Parameter : |
1268: | p_app_rec variable of type ar_receivable_apps_gt |
1269: +-----------------------------------------------------------------------------+
1270: | Action : restore the amounts in the ra_customer_trx_lines_gt |
1271: +-----------------------------------------------------------------------------*/
1272: PROCEDURE res_ctl_rem_amt_for_app

Line 1273: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,

1269: +-----------------------------------------------------------------------------+
1270: | Action : restore the amounts in the ra_customer_trx_lines_gt |
1271: +-----------------------------------------------------------------------------*/
1272: PROCEDURE res_ctl_rem_amt_for_app
1273: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1274: x_return_status IN OUT NOCOPY VARCHAR2)
1275: IS
1276: CURSOR c_app(p_app_rec IN ar_receivable_apps_gt%ROWTYPE)
1277: IS

Line 1276: CURSOR c_app(p_app_rec IN ar_receivable_apps_gt%ROWTYPE)

1272: PROCEDURE res_ctl_rem_amt_for_app
1273: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1274: x_return_status IN OUT NOCOPY VARCHAR2)
1275: IS
1276: CURSOR c_app(p_app_rec IN ar_receivable_apps_gt%ROWTYPE)
1277: IS
1278: SELECT SUM(DECODE(b.ref_account_class,
1279: 'REV',
1280: DECODE(b.REF_DET_ID,NULL,b.AMOUNT,0),

Line 1421: | p_app_rec variable of type ar_receivable_apps_gt |

1417: /*-----------------------------------------------------------------------------+
1418: | Procedure res_inv_ps |
1419: +-----------------------------------------------------------------------------+
1420: | Parameter : |
1421: | p_app_rec variable of type ar_receivable_apps_gt |
1422: +-----------------------------------------------------------------------------+
1423: | Action : restore the amounts in the g_payschedule_trx based on the input|
1424: +-----------------------------------------------------------------------------*/
1425: PROCEDURE res_inv_ps

Line 1426: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,

1422: +-----------------------------------------------------------------------------+
1423: | Action : restore the amounts in the g_payschedule_trx based on the input|
1424: +-----------------------------------------------------------------------------*/
1425: PROCEDURE res_inv_ps
1426: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1427: x_return_status IN OUT NOCOPY VARCHAR2)
1428: IS
1429: l_ps_rec ar_payment_schedules%ROWTYPE;
1430: l_line_discounted NUMBER;

Line 1488: | p_app_rec variable of type ar_receivable_apps_gt |

1484: /*-----------------------------------------------------------------------------+
1485: | Procedure delete_application |
1486: +-----------------------------------------------------------------------------+
1487: | Parameter : |
1488: | p_app_rec variable of type ar_receivable_apps_gt |
1489: +-----------------------------------------------------------------------------+
1490: | Action : |
1491: | 1) Call res_inv_ps to restore payment schedule |
1492: | 2) Call res_ctl_rem_amt_for_app to restore the ra_customer_trx_lines_gt |

Line 1494: | 3) Delete the record from ar_receivable_apps_gt |

1490: | Action : |
1491: | 1) Call res_inv_ps to restore payment schedule |
1492: | 2) Call res_ctl_rem_amt_for_app to restore the ra_customer_trx_lines_gt |
1493: | amounts |
1494: | 3) Delete the record from ar_receivable_apps_gt |
1495: +-----------------------------------------------------------------------------*/
1496: PROCEDURE delete_application
1497: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1498: x_return_status IN OUT NOCOPY VARCHAR2)

Line 1497: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,

1493: | amounts |
1494: | 3) Delete the record from ar_receivable_apps_gt |
1495: +-----------------------------------------------------------------------------*/
1496: PROCEDURE delete_application
1497: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1498: x_return_status IN OUT NOCOPY VARCHAR2)
1499: IS
1500: BEGIN
1501: arp_standard.debug('delete_application +');

Line 1510: -- 3 delete the application from ar_receivable_apps_gt

1506: -- 2 restore inv rem amt
1507: res_ctl_rem_amt_for_app(p_app_rec => p_app_rec,
1508: x_return_status => x_return_status);
1509:
1510: -- 3 delete the application from ar_receivable_apps_gt
1511: DELETE FROM ar_receivable_apps_gt
1512: WHERE gt_id = p_app_rec.gt_id
1513: AND app_level = p_app_rec.app_level;
1514:

Line 1511: DELETE FROM ar_receivable_apps_gt

1507: res_ctl_rem_amt_for_app(p_app_rec => p_app_rec,
1508: x_return_status => x_return_status);
1509:
1510: -- 3 delete the application from ar_receivable_apps_gt
1511: DELETE FROM ar_receivable_apps_gt
1512: WHERE gt_id = p_app_rec.gt_id
1513: AND app_level = p_app_rec.app_level;
1514:
1515: -- 4 delete the distributions created by the application

Line 1532: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,

1528: END delete_application;
1529:
1530:
1531: PROCEDURE copy_app_rec
1532: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1533: x_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,
1534: x_return_status IN OUT NOCOPY VARCHAR2)
1535: IS
1536: BEGIN

Line 1594: | p_app_rec variable of type ar_receivable_apps_gt |

1590: /*-----------------------------------------------------------------------------+
1591: | Procedure do_apply |
1592: +-----------------------------------------------------------------------------+
1593: | Parameter : |
1594: | p_app_rec variable of type ar_receivable_apps_gt |
1595: | p_customer_trx invoice record |
1596: | p_ae_sys_rec receivable system parameter |
1597: | p_gt_id global ID |
1598: +-----------------------------------------------------------------------------+

Line 1602: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,

1598: +-----------------------------------------------------------------------------+
1599: | Action : Call arp_det_dist_pkg to do the application |
1600: +-----------------------------------------------------------------------------*/
1601: PROCEDURE do_apply
1602: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1603: p_gt_id IN VARCHAR2,
1604: x_return_status IN OUT NOCOPY VARCHAR2)
1605: IS
1606: l_ra_rec ar_receivable_applications%ROWTYPE;

Line 1720: l_app_rec ar_receivable_apps_gt%ROWTYPE;

1716: p_charges_uediscounted IN NUMBER,
1717: --
1718: x_return_status IN OUT NOCOPY VARCHAR2)
1719: IS
1720: l_app_rec ar_receivable_apps_gt%ROWTYPE;
1721: BEGIN
1722: arp_standard.debug('apply +');
1723:
1724: arp_standard.debug(' Calling upd_inv_ps +');

Line 1998: | x_app_rec return the current ar_receivable_apps_gt record matching|

1994: | p_app_level Application level TRANSACTION/GROUP/LINE |
1995: | p_group_id Group_id required if level is GROUP |
1996: | p_ctl_id customer_trx_line_id required if level is LINE |
1997: | Out variable |
1998: | x_app_rec return the current ar_receivable_apps_gt record matching|
1999: | the search criteria in ar_receivable_apps_gt |
2000: | Return : |
2001: | Gt_id of that record matching the search criteria |
2002: | If no row found the n returns NO_GT_ID |

Line 1999: | the search criteria in ar_receivable_apps_gt |

1995: | p_group_id Group_id required if level is GROUP |
1996: | p_ctl_id customer_trx_line_id required if level is LINE |
1997: | Out variable |
1998: | x_app_rec return the current ar_receivable_apps_gt record matching|
1999: | the search criteria in ar_receivable_apps_gt |
2000: | Return : |
2001: | Gt_id of that record matching the search criteria |
2002: | If no row found the n returns NO_GT_ID |
2003: +-----------------------------------------------------------------------------+

Line 2005: | Search for the current ar_receivable_apps_gt record that match the criteria|

2001: | Gt_id of that record matching the search criteria |
2002: | If no row found the n returns NO_GT_ID |
2003: +-----------------------------------------------------------------------------+
2004: | Action : |
2005: | Search for the current ar_receivable_apps_gt record that match the criteria|
2006: +-----------------------------------------------------------------------------*/
2007: FUNCTION cur_app_gt_id
2008: ( p_app_level IN VARCHAR2,
2009: p_source_data_key1 IN VARCHAR2,

Line 2015: x_app_rec OUT NOCOPY ar_receivable_apps_gt%ROWTYPE)

2011: p_source_data_key3 IN VARCHAR2,
2012: p_source_data_key4 IN VARCHAR2,
2013: p_source_data_key5 IN VARCHAR2,
2014: p_ctl_id IN NUMBER,
2015: x_app_rec OUT NOCOPY ar_receivable_apps_gt%ROWTYPE)
2016: RETURN VARCHAR2
2017: IS
2018: CURSOR c_trx IS
2019: SELECT *

Line 2020: FROM ar_receivable_apps_gt

2016: RETURN VARCHAR2
2017: IS
2018: CURSOR c_trx IS
2019: SELECT *
2020: FROM ar_receivable_apps_gt
2021: WHERE app_level = 'TRANSACTION';
2022:
2023: CURSOR c_grp IS
2024: SELECT *

Line 2025: FROM ar_receivable_apps_gt

2021: WHERE app_level = 'TRANSACTION';
2022:
2023: CURSOR c_grp IS
2024: SELECT *
2025: FROM ar_receivable_apps_gt
2026: WHERE app_level = 'GROUP'
2027: AND source_data_key1 = p_source_data_key1
2028: AND source_data_key2 = p_source_data_key2
2029: AND source_data_key3 = p_source_data_key3

Line 2035: FROM ar_receivable_apps_gt

2031: AND source_data_key5 = p_source_data_key5;
2032:
2033: CURSOR c_ctl IS
2034: SELECT *
2035: FROM ar_receivable_apps_gt
2036: WHERE app_level = 'LINE'
2037: AND ctl_id = p_ctl_id;
2038: l_res VARCHAR2(30);
2039: BEGIN

Line 2150: l_app_rec ar_receivable_apps_gt%ROWTYPE;

2146: x_msg_count OUT NOCOPY NUMBER,
2147: x_msg_data OUT NOCOPY VARCHAR2)
2148: IS
2149: cur_gt_id VARCHAR2(30);
2150: l_app_rec ar_receivable_apps_gt%ROWTYPE;
2151: unexpected_error EXCEPTION;
2152: BEGIN
2153: arp_standard.debug('application_execute +');
2154: SAVEPOINT first_delete_then_apply;

Line 2272: FROM ar_receivable_apps_gt

2268: SUM(TAX_UEDISCOUNTED),
2269: SUM(FREIGHT_UEDISCOUNTED),
2270: SUM(CHARGES_UEDISCOUNTED),
2271: MAX(receivable_application_id)
2272: FROM ar_receivable_apps_gt
2273: WHERE gt_id = p_gt_id;
2274: BEGIN
2275: OPEN c;
2276: FETCH c INTO

Line 2382: FROM ar_receivable_apps_gt

2378: SUM(TAX_UEDISCOUNTED),
2379: SUM(FREIGHT_UEDISCOUNTED),
2380: SUM(CHARGES_UEDISCOUNTED),
2381: MAX(receivable_application_id)
2382: FROM ar_receivable_apps_gt
2383: WHERE applied_customer_trx_id = g_customer_trx.customer_trx_id;
2384: l_adj_rec ar_adjustments%ROWTYPE;
2385:
2386: x_application_ref_id NUMBER;

Line 2434: UPDATE ar_receivable_apps_gt

2430: UPDATE ar_line_app_detail_gt
2431: SET gt_id = USERENV('SESSIONID')
2432: WHERE gt_id LIKE USERENV('SESSIONID')||'%';
2433: --
2434: UPDATE ar_receivable_apps_gt
2435: SET gt_id = USERENV('SESSIONID')
2436: WHERE gt_id LIKE USERENV('SESSIONID')||'%';
2437:
2438: /*

Line 2588: DELETE FROM ar_receivable_apps_gt where gt_id = TO_CHAR(USERENV('SESSIONID')); /* 5438627 */

2584: g_payschedule_rec := g_payschedule_clr;
2585:
2586: DELETE FROM ra_ar_gt WHERE gt_id = TO_CHAR(USERENV('SESSIONID'));
2587: DELETE FROM ar_line_app_detail_gt WHERE gt_id = TO_CHAR(USERENV('SESSIONID'));
2588: DELETE FROM ar_receivable_apps_gt where gt_id = TO_CHAR(USERENV('SESSIONID')); /* 5438627 */
2589: DELETE FROM ar_ae_alloc_rec_gt where ae_id = TO_CHAR(USERENV('SESSIONID')); /* 5438627 */
2590:
2591:
2592:

Line 2790: FROM ar_receivable_apps_gt;

2786: SUM(NVL(LINE_UEDISCOUNTED,0)) uned_line,
2787: SUM(NVL(TAX_UEDISCOUNTED,0)) uned_tax,
2788: SUM(NVL(FREIGHT_UEDISCOUNTED,0)) uned_frt,
2789: SUM(NVL(CHARGES_UEDISCOUNTED,0)) uned_chrg
2790: FROM ar_receivable_apps_gt;
2791:
2792: CURSOR c_gp_local IS
2793: SELECT SUM(NVL(LINE_APPLIED,0)) app_line,
2794: SUM(NVL(TAX_APPLIED,0)) app_tax,

Line 2799: FROM ar_receivable_apps_gt

2795: SUM(NVL(LINE_EDISCOUNTED,0)) ed_line,
2796: SUM(NVL(TAX_EDISCOUNTED,0)) ed_tax,
2797: SUM(NVL(LINE_UEDISCOUNTED,0)) uned_line,
2798: SUM(NVL(TAX_UEDISCOUNTED,0)) uned_tax
2799: FROM ar_receivable_apps_gt
2800: WHERE SOURCE_DATA_KEY1 = NVL(p_source_data_key1,'00')
2801: AND SOURCE_DATA_KEY2 = NVL(p_source_data_key2,'00')
2802: AND SOURCE_DATA_KEY3 = NVL(p_source_data_key3,'00')
2803: AND SOURCE_DATA_KEY4 = NVL(p_source_data_key4,'00')

Line 2813: FROM ar_receivable_apps_gt

2809: SUM(NVL(LINE_EDISCOUNTED,0)) ed_line,
2810: SUM(NVL(TAX_EDISCOUNTED,0)) ed_tax,
2811: SUM(NVL(LINE_UEDISCOUNTED,0)) uned_line,
2812: SUM(NVL(TAX_UEDISCOUNTED,0)) uned_tax
2813: FROM ar_receivable_apps_gt
2814: WHERE CTL_ID = p_ctl_id;
2815:
2816: CURSOR cu_line IS
2817: SELECT DECODE(line_type,'LINE','OK',line_type)