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.JA_CN_CFS_DATA_CLT_PKG dependencies on JA_CN_CFS_ACTIVITIES_ALL

Line 45: --| ja_cn_cfs_activities_all, not the |

41: --| of the table ja_cn_cfs_activities_gt|
42: --| for bug 5641324 |
43: --| 11/13/2006 Shujuan In procedure Collect_AR_Data, should|
44: --| store the gl_date into the table |
45: --| ja_cn_cfs_activities_all, not the |
46: --| posted gl date for bug 5651671 |
47: --| 5657210. |
48: --| 11/16/2006 Shujuan In procedure Collect_AP_Data,Payment|
49: --| should not be apporationed to the |

Line 993: --Delete all rows from GL and between FROM/TO Periods in table JA_CN_CFS_ACTIVITIES_ALL.

989: ,l_period_start_date
990: ,l_period_end_date ;
991: EXIT WHEN c_period_name%NOTFOUND;
992:
993: --Delete all rows from GL and between FROM/TO Periods in table JA_CN_CFS_ACTIVITIES_ALL.
994: DELETE
995: FROM JA_CN_CFS_ACTIVITIES_ALL s
996: WHERE LEGAL_ENTITY_ID=P_LE_ID
997: -- Fix bug by arming delete start

Line 995: FROM JA_CN_CFS_ACTIVITIES_ALL s

991: EXIT WHEN c_period_name%NOTFOUND;
992:
993: --Delete all rows from GL and between FROM/TO Periods in table JA_CN_CFS_ACTIVITIES_ALL.
994: DELETE
995: FROM JA_CN_CFS_ACTIVITIES_ALL s
996: WHERE LEGAL_ENTITY_ID=P_LE_ID
997: -- Fix bug by arming delete start
998: -- AND SOURCE='GL'
999: -- Fix bug by arming delete end

Line 1058: INSERT INTO JA_CN_CFS_ACTIVITIES_ALL

1054: THEN
1055: l_cash_related_item := l_cash_related_item_1;
1056: END IF;
1057: --insert the row
1058: INSERT INTO JA_CN_CFS_ACTIVITIES_ALL
1059: ( CFS_ACTIVITY_ID
1060: ,LEGAL_ENTITY_ID
1061: ,LEDGER_ID
1062: ,ORG_ID

Line 1152: --Delete all rows from GIS and between FROM/TO Periods in table JA_CN_CFS_ACTIVITIES_ALL.

1148: ,l_period_start_date
1149: ,l_period_end_date ;
1150: EXIT WHEN c_period_name%NOTFOUND;
1151:
1152: --Delete all rows from GIS and between FROM/TO Periods in table JA_CN_CFS_ACTIVITIES_ALL.
1153: DELETE
1154: FROM JA_CN_CFS_ACTIVITIES_ALL
1155: WHERE LEGAL_ENTITY_ID = l_le_id
1156: AND PERIOD_NAME = l_period_name

Line 1154: FROM JA_CN_CFS_ACTIVITIES_ALL

1150: EXIT WHEN c_period_name%NOTFOUND;
1151:
1152: --Delete all rows from GIS and between FROM/TO Periods in table JA_CN_CFS_ACTIVITIES_ALL.
1153: DELETE
1154: FROM JA_CN_CFS_ACTIVITIES_ALL
1155: WHERE LEGAL_ENTITY_ID = l_le_id
1156: AND PERIOD_NAME = l_period_name
1157: --AND SOURCE = 'GIS' --fix bug 7488206 delete
1158: AND SOURCE=l_source_name ;--fix bug 7488206 add

Line 1276: INSERT INTO JA_CN_CFS_ACTIVITIES_ALL

1272: ,P_CURRENCY_CODE => l_trxb_curr_code
1273: ,P_AMOUNT_ROUNDED => l_tr_func_amount
1274: );
1275: --insert the row
1276: INSERT INTO JA_CN_CFS_ACTIVITIES_ALL
1277: ( CFS_ACTIVITY_ID
1278: ,LEGAL_ENTITY_ID
1279: ,LEDGER_ID
1280: ,ORG_ID