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.PA_TXN_ACCUMS dependencies on PA_COMMITMENT_TXNS

Line 22: pa_commitment_txns_s.NEXTVAL

18: FUNCTION cmt_line_id RETURN NUMBER IS
19: cmt_line_id NUMBER;
20: BEGIN
21: SELECT
22: pa_commitment_txns_s.NEXTVAL
23: INTO cmt_line_id
24: FROM
25: SYS.DUAL;
26: RETURN cmt_line_id;

Line 1225: -- This procedure deletes the pa_commitment_txns which were refreshed

1221: x_err_code := SQLCODE;
1222: RAISE;
1223: END create_txn_accum;
1224:
1225: -- This procedure deletes the pa_commitment_txns which were refreshed
1226:
1227: PROCEDURE delete_cmt_txns
1228: ( x_start_project_id IN NUMBER,
1229: x_end_project_id IN NUMBER,

Line 1255: pa_commitment_txns pct

1251:
1252:
1253: LOOP
1254: DELETE
1255: pa_commitment_txns pct
1256: WHERE
1257: pct.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id -- Commented out for bug 3736097
1258: -- System_linkage_function can be Null for commitments
1259: AND NVL(pct.system_linkage_function,'X') =

Line 1295: -- This procedure creates the commitment txns into pa_commitment_txns

1291: x_err_code := SQLCODE;
1292: RAISE;
1293: END delete_cmt_txns;
1294:
1295: -- This procedure creates the commitment txns into pa_commitment_txns
1296: -- from the view pa_commitment_txns_v
1297:
1298: --
1299: -- Name: Create_Cmt_Txns

Line 1296: -- from the view pa_commitment_txns_v

1292: RAISE;
1293: END delete_cmt_txns;
1294:
1295: -- This procedure creates the commitment txns into pa_commitment_txns
1296: -- from the view pa_commitment_txns_v
1297:
1298: --
1299: -- Name: Create_Cmt_Txns
1300: --

Line 1363: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_V Source';

1359: ELSE
1360:
1361: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1362: IF x_use_tmp_table = 'N' THEN /* 14457478 */
1363: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_V Source';
1364: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1365: ELSIF x_use_tmp_table = 'Y' THEN
1366: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_TMP Source';
1367: pa_debug.debug('create_cmt_txns: ' || x_err_stage);

Line 1366: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_TMP Source';

1362: IF x_use_tmp_table = 'N' THEN /* 14457478 */
1363: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_V Source';
1364: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1365: ELSIF x_use_tmp_table = 'Y' THEN
1366: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_TMP Source';
1367: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1368: END IF; /* 14457478 */
1369: END IF;
1370:

Line 1371: -- Insert Commitments from the Oracle Projects User-Defined PA_COMMITMENT_TXNS_V

1367: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1368: END IF; /* 14457478 */
1369: END IF;
1370:
1371: -- Insert Commitments from the Oracle Projects User-Defined PA_COMMITMENT_TXNS_V
1372: -- View.
1373:
1374: if (x_start_project_id is not null) then -- refresh cmts for single prj
1375:

Line 1399: INSERT INTO pa_commitment_txns

1395:
1396: /* End of commitment change request*/
1397: IF x_use_tmp_table='N' THEN /*Added for bug 5635857*/
1398:
1399: INSERT INTO pa_commitment_txns
1400: ( CMT_LINE_ID,
1401: PROJECT_ID,
1402: TASK_ID,
1403: TRANSACTION_SOURCE,

Line 1592: pa_commitment_txns_v pctv

1588: pctv.wip_resource_id,
1589: pctv.resource_class,
1590: pctv.cbs_element_id --16461684
1591: FROM
1592: pa_commitment_txns_v pctv
1593: WHERE
1594: pctv.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id commented for bug 3736097
1595: AND NVL(pctv.system_linkage_function,'X') =
1596: NVL(NVL(x_system_linkage_function,pctv.system_linkage_function),'X')

Line 1610: INSERT INTO pa_commitment_txns

1606: AND pctv.SYSTEM_LINKAGE_FUNCTION IS NOT NULL ;
1607: /* 14457478 */
1608:
1609: ELSIF x_use_tmp_table='Y' THEN /*Start of addition for bug 5635857*/
1610: INSERT INTO pa_commitment_txns
1611: ( CMT_LINE_ID,
1612: PROJECT_ID,
1613: TASK_ID,
1614: TRANSACTION_SOURCE,

Line 1801: pa_commitment_txns_tmp pctv

1797: pctv.wip_resource_id,
1798: pctv.wip_resource_id,
1799: pctv.resource_class
1800: FROM
1801: pa_commitment_txns_tmp pctv
1802: WHERE
1803: pctv.project_id = x_start_project_id
1804: /* 14457478 */
1805: AND pctv.PROJECT_ID IS NOT NULL

Line 1992: insert into PA_COMMITMENT_TXNS

1988: end loop;
1989:
1990: IF x_use_tmp_table='N' THEN /*Added for bug 5635857*/
1991:
1992: insert into PA_COMMITMENT_TXNS
1993: (
1994: CMT_LINE_ID,
1995: PROJECT_ID,
1996: TASK_ID,

Line 2084: PA_COMMITMENT_TXNS_S.NEXTVAL CMT_LINE_ID,

2080: RESOURCE_CLASS,
2081: CBS_ELEMENT_ID --16461684
2082: )
2083: select /*+ push_pred(pctv) */
2084: PA_COMMITMENT_TXNS_S.NEXTVAL CMT_LINE_ID,
2085: pctv.PROJECT_ID,
2086: pctv.TASK_ID,
2087: pctv.TRANSACTION_SOURCE,
2088: decode(pctv.LINE_TYPE,

Line 2225: PA_COMMITMENT_TXNS_V pctv

2221: pctv.WIP_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID,
2222: pctv.RESOURCE_CLASS,
2223: pctv.CBS_ELEMENT_ID --16461684
2224: from
2225: PA_COMMITMENT_TXNS_V pctv
2226: where
2227: pctv.PROJECT_ID = l_project_id_1
2228: /* 14457478 */
2229: AND pctv.PROJECT_ID IS NOT NULL

Line 2266: insert into PA_COMMITMENT_TXNS

2262: */
2263:
2264: /* Start of Addition for bug 5635857*/
2265: ELSIF x_use_tmp_table='Y' THEN
2266: insert into PA_COMMITMENT_TXNS
2267: (
2268: CMT_LINE_ID,
2269: PROJECT_ID,
2270: TASK_ID,

Line 2357: PA_COMMITMENT_TXNS_S.NEXTVAL CMT_LINE_ID,

2353: BOM_EQUIPMENT_RESOURCE_ID,
2354: RESOURCE_CLASS
2355: )
2356: select
2357: PA_COMMITMENT_TXNS_S.NEXTVAL CMT_LINE_ID,
2358: pctv.PROJECT_ID,
2359: pctv.TASK_ID,
2360: pctv.TRANSACTION_SOURCE,
2361: pctv.LINE_TYPE,

Line 2493: pa_commitment_txns_tmp pctv

2489: pctv.WIP_RESOURCE_ID BOM_LABOR_RESOURCE_ID,
2490: pctv.WIP_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID,
2491: pctv.RESOURCE_CLASS
2492: from
2493: pa_commitment_txns_tmp pctv
2494: WHERE
2495: pctv.PROJECT_ID = l_project_id_1
2496: /* 14457478 */
2497: AND pctv.PROJECT_ID IS NOT NULL

Line 3946: -- The cursor selcmts selects all PA_COMMITMENT_TXNS which

3942: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3943: --
3944: -- Cursors ---------------------------------------------------
3945: --
3946: -- The cursor selcmts selects all PA_COMMITMENT_TXNS which
3947: -- satisfy the given parameters
3948:
3949: CURSOR selcmts IS
3950: SELECT

Line 3979: pa_commitment_txns pct

3975: pct.receipt_currency_code,
3976: pct.receipt_currency_amount,
3977: pct.receipt_exchange_rate
3978: FROM
3979: pa_commitment_txns pct
3980: -- Bug#2634995 - removed the reference to pa_implentations as it is not used in the SQL
3981: -- ,pa_implementations pi
3982: WHERE
3983: pct.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id commented for bug 3736097

Line 4013: l_cmt_rejection_code pa_commitment_txns.cmt_rejection_code%TYPE;

4009: cmtrec selcmts%ROWTYPE;
4010: x_txn_accum_id NUMBER;
4011: row_processed NUMBER;
4012: l_cmtrec_curr_OK VARCHAR2(1);
4013: l_cmt_rejection_code pa_commitment_txns.cmt_rejection_code%TYPE;
4014: l_err_msg VARCHAR2(2000);
4015:
4016: -- Client Extension API Variables
4017: l_Project_Rate_Type pa_commitment_txns.project_rate_type%TYPE;

Line 4017: l_Project_Rate_Type pa_commitment_txns.project_rate_type%TYPE;

4013: l_cmt_rejection_code pa_commitment_txns.cmt_rejection_code%TYPE;
4014: l_err_msg VARCHAR2(2000);
4015:
4016: -- Client Extension API Variables
4017: l_Project_Rate_Type pa_commitment_txns.project_rate_type%TYPE;
4018: l_Project_Rate_Date DATE;
4019: l_project_exch_rate NUMBER;
4020: l_Num_Rate NUMBER;
4021: l_Denom_Rate NUMBER;

Line 4024: l_Msg_Data pa_commitment_txns.cmt_rejection_code%TYPE;

4020: l_Num_Rate NUMBER;
4021: l_Denom_Rate NUMBER;
4022: l_Converted_Amount NUMBER;
4023: l_Msg_Application fnd_application.application_short_name%TYPE;
4024: l_Msg_Data pa_commitment_txns.cmt_rejection_code%TYPE;
4025: l_Msg_Count NUMBER;
4026:
4027: -- Multicurrency API Variables
4028: l_amount_out NUMBER;

Line 4038: l_PROJFUNC_COST_RATE_TYPE pa_commitment_txns.project_rate_type%TYPE := NULL;

4034: -- Bug 2119738: New Parameters
4035: l_SYSTEM_LINKAGE pa_expenditure_items_all.SYSTEM_LINKAGE_FUNCTION%TYPE :=NULL;
4036: l_PROJECT_RAW_COST NUMBER := NULL;
4037: l_PROJFUNC_CURR_CODE pa_projects.project_currency_code%TYPE := NULL;
4038: l_PROJFUNC_COST_RATE_TYPE pa_commitment_txns.project_rate_type%TYPE := NULL;
4039: l_PROJFUNC_COST_RATE_DATE DATE := NULL;
4040: l_PROJFUNC_COST_EXCH_RATE NUMBER := NULL;
4041:
4042: -- added for FP.M

Line 4254: UPDATE pa_commitment_txns

4250: --
4251:
4252: IF (l_cmtrec_curr_OK = 'Y')
4253: THEN
4254: UPDATE pa_commitment_txns
4255: SET tot_cmt_raw_cost = l_tot_cmt_raw_cost
4256: , tot_cmt_burdened_cost = l_tot_cmt_burdened_cost
4257: , project_currency_code = l_project_curr_code
4258: , project_rate_date = l_project_rate_date

Line 4267: UPDATE pa_commitment_txns

4263: WHERE cmt_line_id = cmtrec.cmt_line_id;
4264:
4265: ELSE
4266:
4267: UPDATE pa_commitment_txns
4268: SET generation_error_flag = 'Y'
4269: , cmt_rejection_code = l_cmt_rejection_code
4270: WHERE cmt_line_id = cmtrec.cmt_line_id;
4271: