1609: ,l_concat_segments
1610: ,l_fail_count);
1611: IF l_credit_ccid IS NULL
1612: THEN
1613: l_credit_ccid := FND_FLEX_EXT.GET_CCID
1614: ('SQLGL'
1615: ,'GL#'
1616: ,arp_global.chart_of_accounts_id
1617: ,TO_CHAR(l_rev_adj_rec.gl_date,'DD-MON-YYYY')
1721: ,l_fail_count);
1722: IF l_debit_ccid IS NULL
1723: THEN
1724: l_debit_ccid :=
1725: FND_FLEX_EXT.GET_CCID
1726: ('SQLGL'
1727: ,'GL#'
1728: ,arp_global.chart_of_accounts_id
1729: ,TO_CHAR(l_rev_adj_rec.gl_date,'DD-MON-YYYY')
3080: ,l_debit_concat_segments
3081: ,l_fail_count);
3082: IF l_debit_ccid IS NULL
3083: THEN
3084: l_debit_ccid := FND_FLEX_EXT.GET_CCID
3085: ('SQLGL',
3086: 'GL#',
3087: arp_global.chart_of_accounts_id,
3088: to_char(TRUNC(SYSDATE),'DD-MON-YYYY'),
3124: l_revenue_type := 'UNEARN';
3125: IF l_credit_ccid IS NULL
3126: THEN
3127: l_credit_ccid :=
3128: FND_FLEX_EXT.GET_CCID('SQLGL',
3129: 'GL#',
3130: arp_global.chart_of_accounts_id,
3131: TO_CHAR(TRUNC(SYSDATE),'DD-MON-YYYY') ,
3132: l_credit_concat_segments);
3516: ,l_concat_segments
3517: ,l_fail_count);
3518: IF l_debit_ccid IS NULL
3519: THEN
3520: l_debit_ccid := FND_FLEX_EXT.GET_CCID
3521: ('SQLGL',
3522: 'GL#',
3523: arp_global.chart_of_accounts_id,
3524: to_char(p_gl_date,'DD-MON-YYYY') ,
3577:
3578: IF l_credit_ccid IS NULL
3579: THEN
3580: l_credit_ccid :=
3581: FND_FLEX_EXT.GET_CCID ('SQLGL',
3582: 'GL#',
3583: arp_global.chart_of_accounts_id,
3584: TO_CHAR(p_gl_date,'DD-MON-YYYY') ,
3585: l_concat_segments);
3773: ,l_concat_segments
3774: ,l_fail_count);
3775: IF l_debit_ccid IS NULL
3776: THEN
3777: l_debit_ccid := FND_FLEX_EXT.GET_CCID
3778: ('SQLGL',
3779: 'GL#',
3780: arp_global.chart_of_accounts_id,
3781: to_char(p_gl_date,'DD-MON-YYYY') ,
3845:
3846: IF l_credit_ccid IS NULL
3847: THEN
3848: l_credit_ccid :=
3849: FND_FLEX_EXT.GET_CCID ('SQLGL',
3850: 'GL#',
3851: arp_global.chart_of_accounts_id,
3852: TO_CHAR(p_gl_date,'DD-MON-YYYY') ,
3853: l_concat_segments);
4855: ,l_fail_count);
4856:
4857: IF l_credit_ccid IS NULL
4858: THEN
4859: l_credit_ccid := FND_FLEX_EXT.GET_CCID
4860: ('SQLGL',
4861: 'GL#',
4862: arp_global.chart_of_accounts_id,
4863: TO_CHAR(p_gl_date,'DD-MON-YYYY'),
5249: ,l_concat_segments
5250: ,l_fail_count);
5251: IF l_ccid IS NULL
5252: THEN
5253: l_ccid := FND_FLEX_EXT.GET_CCID
5254: ('SQLGL'
5255: ,'GL#'
5256: ,arp_global.chart_of_accounts_id
5257: ,TO_CHAR(p_gl_date,'DD-MON-YYYY')