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 1362: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_V Source';

1358:
1359: ELSE
1360:
1361: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1362: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_V Source';
1363: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1364: END IF;
1365:
1366: -- Insert Commitments from the Oracle Projects User-Defined PA_COMMITMENT_TXNS_V

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

1362: x_err_stage := 'Creating commitment txns from PA_COMMITMENT_TXNS_V Source';
1363: pa_debug.debug('create_cmt_txns: ' || x_err_stage);
1364: END IF;
1365:
1366: -- Insert Commitments from the Oracle Projects User-Defined PA_COMMITMENT_TXNS_V
1367: -- View.
1368:
1369: if (x_start_project_id is not null) then -- refresh cmts for single prj
1370:

Line 1394: INSERT INTO pa_commitment_txns

1390:
1391: /* End of commitment change request*/
1392: IF x_use_tmp_table='N' THEN /*Added for bug 5635857*/
1393:
1394: INSERT INTO pa_commitment_txns
1395: ( CMT_LINE_ID,
1396: PROJECT_ID,
1397: TASK_ID,
1398: TRANSACTION_SOURCE,

Line 1577: pa_commitment_txns_v pctv

1573: pctv.wip_resource_id,
1574: pctv.wip_resource_id,
1575: pctv.resource_class
1576: FROM
1577: pa_commitment_txns_v pctv
1578: WHERE
1579: pctv.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id commented for bug 3736097
1580: AND NVL(pctv.system_linkage_function,'X') =
1581: NVL(NVL(x_system_linkage_function,pctv.system_linkage_function),'X');

Line 1584: INSERT INTO pa_commitment_txns

1580: AND NVL(pctv.system_linkage_function,'X') =
1581: NVL(NVL(x_system_linkage_function,pctv.system_linkage_function),'X');
1582:
1583: ELSIF x_use_tmp_table='Y' THEN /*Start of addition for bug 5635857*/
1584: INSERT INTO pa_commitment_txns
1585: ( CMT_LINE_ID,
1586: PROJECT_ID,
1587: TASK_ID,
1588: TRANSACTION_SOURCE,

Line 1767: pa_commitment_txns_tmp pctv

1763: pctv.wip_resource_id,
1764: pctv.wip_resource_id,
1765: pctv.resource_class
1766: FROM
1767: pa_commitment_txns_tmp pctv
1768: WHERE
1769: pctv.project_id = x_start_project_id ;
1770:
1771: end if; /* End of Addition for bug 5635857*/

Line 1947: insert into PA_COMMITMENT_TXNS

1943: end loop;
1944:
1945: IF x_use_tmp_table='N' THEN /*Added for bug 5635857*/
1946:
1947: insert into PA_COMMITMENT_TXNS
1948: (
1949: CMT_LINE_ID,
1950: PROJECT_ID,
1951: TASK_ID,

Line 2038: PA_COMMITMENT_TXNS_S.NEXTVAL CMT_LINE_ID,

2034: BOM_EQUIPMENT_RESOURCE_ID,
2035: RESOURCE_CLASS
2036: )
2037: select /*+ push_pred(pctv) */
2038: PA_COMMITMENT_TXNS_S.NEXTVAL CMT_LINE_ID,
2039: pctv.PROJECT_ID,
2040: pctv.TASK_ID,
2041: pctv.TRANSACTION_SOURCE,
2042: decode(pctv.LINE_TYPE,

Line 2170: PA_COMMITMENT_TXNS_V pctv

2166: pctv.WIP_RESOURCE_ID BOM_LABOR_RESOURCE_ID,
2167: pctv.WIP_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID,
2168: pctv.RESOURCE_CLASS
2169: from
2170: PA_COMMITMENT_TXNS_V pctv
2171: where
2172: pctv.PROJECT_ID = l_project_id_1;
2173:
2174: /* single project batch

Line 2200: insert into PA_COMMITMENT_TXNS

2196: */
2197:
2198: /* Start of Addition for bug 5635857*/
2199: ELSIF x_use_tmp_table='Y' THEN
2200: insert into PA_COMMITMENT_TXNS
2201: (
2202: CMT_LINE_ID,
2203: PROJECT_ID,
2204: TASK_ID,

Line 2291: PA_COMMITMENT_TXNS_S.NEXTVAL CMT_LINE_ID,

2287: BOM_EQUIPMENT_RESOURCE_ID,
2288: RESOURCE_CLASS
2289: )
2290: select
2291: PA_COMMITMENT_TXNS_S.NEXTVAL CMT_LINE_ID,
2292: pctv.PROJECT_ID,
2293: pctv.TASK_ID,
2294: pctv.TRANSACTION_SOURCE,
2295: pctv.LINE_TYPE,

Line 2419: pa_commitment_txns_tmp pctv

2415: pctv.WIP_RESOURCE_ID BOM_LABOR_RESOURCE_ID,
2416: pctv.WIP_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID,
2417: pctv.RESOURCE_CLASS
2418: from
2419: pa_commitment_txns_tmp pctv
2420: WHERE
2421: pctv.PROJECT_ID = l_project_id_1;
2422: end if;
2423: /* End of Addition for bug 5635857*/

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

3762: P_DEBUG_MODE varchar2(1) :=NVL(FND_PROFILE.VALUE('PA_DEBUG_MODE'),'N');/*Added the default profile option variable initialization for bug 2674619*/
3763: --
3764: -- Cursors ---------------------------------------------------
3765: --
3766: -- The cursor selcmts selects all PA_COMMITMENT_TXNS which
3767: -- satisfy the given parameters
3768:
3769: CURSOR selcmts IS
3770: SELECT

Line 3799: pa_commitment_txns pct

3795: pct.receipt_currency_code,
3796: pct.receipt_currency_amount,
3797: pct.receipt_exchange_rate
3798: FROM
3799: pa_commitment_txns pct
3800: -- Bug#2634995 - removed the reference to pa_implentations as it is not used in the SQL
3801: -- ,pa_implementations pi
3802: WHERE
3803: pct.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id commented for bug 3736097

Line 3833: l_cmt_rejection_code pa_commitment_txns.cmt_rejection_code%TYPE;

3829: cmtrec selcmts%ROWTYPE;
3830: x_txn_accum_id NUMBER;
3831: row_processed NUMBER;
3832: l_cmtrec_curr_OK VARCHAR2(1);
3833: l_cmt_rejection_code pa_commitment_txns.cmt_rejection_code%TYPE;
3834: l_err_msg VARCHAR2(2000);
3835:
3836: -- Client Extension API Variables
3837: l_Project_Rate_Type pa_commitment_txns.project_rate_type%TYPE;

Line 3837: l_Project_Rate_Type pa_commitment_txns.project_rate_type%TYPE;

3833: l_cmt_rejection_code pa_commitment_txns.cmt_rejection_code%TYPE;
3834: l_err_msg VARCHAR2(2000);
3835:
3836: -- Client Extension API Variables
3837: l_Project_Rate_Type pa_commitment_txns.project_rate_type%TYPE;
3838: l_Project_Rate_Date DATE;
3839: l_project_exch_rate NUMBER;
3840: l_Num_Rate NUMBER;
3841: l_Denom_Rate NUMBER;

Line 3844: l_Msg_Data pa_commitment_txns.cmt_rejection_code%TYPE;

3840: l_Num_Rate NUMBER;
3841: l_Denom_Rate NUMBER;
3842: l_Converted_Amount NUMBER;
3843: l_Msg_Application fnd_application.application_short_name%TYPE;
3844: l_Msg_Data pa_commitment_txns.cmt_rejection_code%TYPE;
3845: l_Msg_Count NUMBER;
3846:
3847: -- Multicurrency API Variables
3848: l_amount_out NUMBER;

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

3854: -- Bug 2119738: New Parameters
3855: l_SYSTEM_LINKAGE pa_expenditure_items_all.SYSTEM_LINKAGE_FUNCTION%TYPE :=NULL;
3856: l_PROJECT_RAW_COST NUMBER := NULL;
3857: l_PROJFUNC_CURR_CODE pa_projects.project_currency_code%TYPE := NULL;
3858: l_PROJFUNC_COST_RATE_TYPE pa_commitment_txns.project_rate_type%TYPE := NULL;
3859: l_PROJFUNC_COST_RATE_DATE DATE := NULL;
3860: l_PROJFUNC_COST_EXCH_RATE NUMBER := NULL;
3861:
3862: -- added for FP.M

Line 4068: UPDATE pa_commitment_txns

4064: --
4065:
4066: IF (l_cmtrec_curr_OK = 'Y')
4067: THEN
4068: UPDATE pa_commitment_txns
4069: SET tot_cmt_raw_cost = l_tot_cmt_raw_cost
4070: , tot_cmt_burdened_cost = l_tot_cmt_burdened_cost
4071: , project_currency_code = l_project_curr_code
4072: , project_rate_date = l_project_rate_date

Line 4081: UPDATE pa_commitment_txns

4077: WHERE cmt_line_id = cmtrec.cmt_line_id;
4078:
4079: ELSE
4080:
4081: UPDATE pa_commitment_txns
4082: SET generation_error_flag = 'Y'
4083: , cmt_rejection_code = l_cmt_rejection_code
4084: WHERE cmt_line_id = cmtrec.cmt_line_id;
4085: