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 1016: --Delete all rows from GL and between FROM/TO Periods in table JA_CN_CFS_ACTIVITIES_ALL.

1012: ,l_period_start_date
1013: ,l_period_end_date ;
1014: EXIT WHEN c_period_name%NOTFOUND;
1015:
1016: --Delete all rows from GL and between FROM/TO Periods in table JA_CN_CFS_ACTIVITIES_ALL.
1017: DELETE
1018: FROM JA_CN_CFS_ACTIVITIES_ALL s
1019: WHERE LEGAL_ENTITY_ID=P_LE_ID
1020: --Start bug 12379032 by jianchao chi, add the ledger id condition

Line 1018: FROM JA_CN_CFS_ACTIVITIES_ALL s

1014: EXIT WHEN c_period_name%NOTFOUND;
1015:
1016: --Delete all rows from GL and between FROM/TO Periods in table JA_CN_CFS_ACTIVITIES_ALL.
1017: DELETE
1018: FROM JA_CN_CFS_ACTIVITIES_ALL s
1019: WHERE LEGAL_ENTITY_ID=P_LE_ID
1020: --Start bug 12379032 by jianchao chi, add the ledger id condition
1021: AND LEDGER_ID = P_LEDGER_ID
1022: --End bug 12379032

Line 1084: INSERT INTO JA_CN_CFS_ACTIVITIES_ALL

1080: THEN
1081: l_cash_related_item := l_cash_related_item_1;
1082: END IF;
1083: --insert the row
1084: INSERT INTO JA_CN_CFS_ACTIVITIES_ALL
1085: ( CFS_ACTIVITY_ID
1086: ,LEGAL_ENTITY_ID
1087: ,LEDGER_ID
1088: ,ORG_ID

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

1174: ,l_period_start_date
1175: ,l_period_end_date ;
1176: EXIT WHEN c_period_name%NOTFOUND;
1177:
1178: --Delete all rows from GIS and between FROM/TO Periods in table JA_CN_CFS_ACTIVITIES_ALL.
1179: DELETE
1180: FROM JA_CN_CFS_ACTIVITIES_ALL
1181: WHERE LEGAL_ENTITY_ID = l_le_id
1182: --Start bug 12379032 by jianchao chi, add the ledger id condition

Line 1180: FROM JA_CN_CFS_ACTIVITIES_ALL

1176: EXIT WHEN c_period_name%NOTFOUND;
1177:
1178: --Delete all rows from GIS and between FROM/TO Periods in table JA_CN_CFS_ACTIVITIES_ALL.
1179: DELETE
1180: FROM JA_CN_CFS_ACTIVITIES_ALL
1181: WHERE LEGAL_ENTITY_ID = l_le_id
1182: --Start bug 12379032 by jianchao chi, add the ledger id condition
1183: AND LEDGER_ID = P_LEDGER_ID
1184: --End bug 12379032

Line 1324: INSERT INTO JA_CN_CFS_ACTIVITIES_ALL

1320: l_je_line_num :='';
1321: END;
1322:
1323: --insert the row
1324: INSERT INTO JA_CN_CFS_ACTIVITIES_ALL
1325: ( CFS_ACTIVITY_ID
1326: ,LEGAL_ENTITY_ID
1327: ,LEDGER_ID
1328: ,ORG_ID