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.CSC_PROFILE_ENGINE_PKG dependencies on CSC_PROF_BLOCK_RESULTS

Line 6139: -- result in the CSC_PROF_BLOCK_RESULTS table.

6135: /* End of R12 Employee HelpDesk Modifications */
6136: --
6137: -- Evaluate_One_Block
6138: -- Execute dynamic SQL to evaluate the given building block and store the
6139: -- result in the CSC_PROF_BLOCK_RESULTS table.
6140: -- IN
6141: -- blk_id - profile check building block identifier
6142: -- party_id - customer identifier for which building block is evaluated
6143: -- acct_id - account id

Line 6178: From csc_prof_block_results

6174: /*
6175: -- for party level
6176: Cursor party_block_crs IS
6177: Select count(*)
6178: From csc_prof_block_results
6179: Where block_id = p_blk_id
6180: And party_id = p_party_id
6181: And cust_account_id IS NULL;
6182:

Line 6186: From csc_prof_block_results

6182:
6183: -- for account level
6184: Cursor account_block_crs IS
6185: Select count(*)
6186: From csc_prof_block_results
6187: Where block_id = p_blk_id
6188: And party_id = p_party_id
6189: And cust_account_id = p_acct_id;
6190: */

Line 6273: select 1 into v_party_count from csc_prof_block_results

6269:
6270: IF p_acct_id IS NULL THEN
6271: IF p_truncate_flag = 'N' THEN
6272: begin
6273: select 1 into v_party_count from csc_prof_block_results
6274: where block_id = p_blk_id
6275: and party_id = p_party_id
6276: and cust_account_id is null;
6277: exception

Line 6336: select 1 into v_account_count from csc_prof_block_results

6332:
6333: ELSE
6334: IF p_truncate_flag = 'N' THEN
6335: begin
6336: select 1 into v_account_count from csc_prof_block_results
6337: where block_id = p_blk_id
6338: and party_id = p_party_id
6339: and cust_account_id = p_acct_id;
6340: exception when no_data_found then

Line 6418: -- Insert or Update Records into Csc_Prof_Block_Results Table

6414: END Evaluate_One_Block;
6415:
6416:
6417: --
6418: -- Insert or Update Records into Csc_Prof_Block_Results Table
6419: -- IN
6420: -- p_count - the number of records to be inserted or updated
6421: -- p_for_party - flag to check if the insert or update is for party or account
6422: -- p_for_insert - flag to check if for insert or update.

Line 6445: -- Insert Records into Csc_Prof_Block_Results Table

6441:
6442: IF p_for_party = 'Y' THEN
6443: -- PARTY level insert or update of records
6444: IF p_for_insert = 'Y' THEN
6445: -- Insert Records into Csc_Prof_Block_Results Table
6446: FORALL i IN 1..p_count
6447: INSERT INTO Csc_Prof_Block_Results
6448: ( block_results_id
6449: , block_id

Line 6447: INSERT INTO Csc_Prof_Block_Results

6443: -- PARTY level insert or update of records
6444: IF p_for_insert = 'Y' THEN
6445: -- Insert Records into Csc_Prof_Block_Results Table
6446: FORALL i IN 1..p_count
6447: INSERT INTO Csc_Prof_Block_Results
6448: ( block_results_id
6449: , block_id
6450: , party_id
6451: , cust_account_id

Line 6460: (csc_prof_block_results_s.nextval

6456: , last_updated_by
6457: , last_update_date
6458: , last_update_login)
6459: VALUES
6460: (csc_prof_block_results_s.nextval
6461: , ip_block_id(i)
6462: , ip_party_id(i)
6463: , ip_account_id(i)
6464: , ip_value(i)

Line 6479: UPDATE Csc_Prof_Block_Results

6475: ip_value.DELETE;
6476: ip_currency.DELETE;
6477: ELSE
6478: FORALL i IN 1..p_count
6479: UPDATE Csc_Prof_Block_Results
6480: Set value = up_value(i)
6481: , currency_code = up_currency(i)
6482: , last_updated_by = FND_GLOBAL.USER_ID
6483: , last_update_date = sysdate

Line 6497: -- Insert Records into Csc_Prof_Block_Results Table

6493: END IF;
6494: ELSE
6495: -- ACCOUNT level insert or update of records
6496: IF p_for_insert = 'Y' THEN
6497: -- Insert Records into Csc_Prof_Block_Results Table
6498: FORALL i IN 1..p_count
6499: INSERT INTO Csc_Prof_Block_Results
6500: ( block_results_id
6501: , block_id

Line 6499: INSERT INTO Csc_Prof_Block_Results

6495: -- ACCOUNT level insert or update of records
6496: IF p_for_insert = 'Y' THEN
6497: -- Insert Records into Csc_Prof_Block_Results Table
6498: FORALL i IN 1..p_count
6499: INSERT INTO Csc_Prof_Block_Results
6500: ( block_results_id
6501: , block_id
6502: , party_id
6503: , cust_account_id

Line 6512: (csc_prof_block_results_s.nextval

6508: , last_updated_by
6509: , last_update_date
6510: , last_update_login)
6511: VALUES
6512: (csc_prof_block_results_s.nextval
6513: , ia_block_id(i)
6514: , ia_party_id(i)
6515: , ia_account_id(i)
6516: , ia_value(i)

Line 6531: UPDATE Csc_Prof_Block_Results

6527: ia_value.DELETE;
6528: ia_currency.DELETE;
6529: ELSE
6530: FORALL i IN 1..p_count
6531: UPDATE Csc_Prof_Block_Results
6532: Set value = ua_value(i)
6533: , currency_code = ua_currency(i)
6534: , last_updated_by = FND_GLOBAL.USER_ID
6535: , last_update_date = sysdate

Line 7593: -- FROM csc_prof_block_results

7589: -- EXISTS ( {subquery} )
7590: --
7591: -- A {subquery} has the following three forms:
7592: -- SELECT 1
7593: -- FROM csc_prof_block_results
7594: -- WHERE block_id =
7595: -- AND party_id =
7596: -- AND value [ [AND ]]
7597: --

Line 7610: 'EXISTS (SELECT 1 FROM csc_prof_block_results WHERE block_id = ' ||

7606: close blk_crs;
7607: if v_blk_level='PARTY' then
7608: rule := rule || ' ' || rules_rec.logical_operator || ' ' ||
7609: rules_rec.left_paren ||
7610: 'EXISTS (SELECT 1 FROM csc_prof_block_results WHERE block_id = ' ||
7611: rules_rec.block_id || ' AND party_id = :party_id' ||
7612: ' AND cust_account_id IS NULL AND value ' || rules_rec.comparison_operator;
7613:
7614: IF rules_rec.expression IS NOT NULL THEN

Line 7619: rule := rule || '(SELECT value FORM csc_prof_block_results WHERE block_id = '||

7615: IF (rules_rec.comparison_operator NOT IN ('IS NULL', 'IS NOT NULL')) THEN
7616: rule := rule || ' ' || rules_rec.expression;
7617: END IF;
7618: ELSE
7619: rule := rule || '(SELECT value FORM csc_prof_block_results WHERE block_id = '||
7620: rules_rec.expr_to_block_id || ' AND cust_account_id IS NULL )';
7621: END IF;
7622:
7623: rule := rule || ')' || rules_rec.right_paren;

Line 7629: 'EXISTS (SELECT 1 FROM csc_prof_block_results WHERE block_id = ' ||

7625: ELSIF v_blk_level='ACCOUNT' then
7626:
7627: rule := rule || ' ' || rules_rec.logical_operator || ' ' ||
7628: rules_rec.left_paren ||
7629: 'EXISTS (SELECT 1 FROM csc_prof_block_results WHERE block_id = ' ||
7630: rules_rec.block_id || ' AND party_id = :party_id' ||
7631: ' AND cust_account_id = :cust_account_id' ||
7632: ' AND value ' || rules_rec.comparison_operator;
7633:

Line 7639: rule := rule || '(SELECT value FORM csc_prof_block_results WHERE block_id = '

7635: IF (rules_rec.comparison_operator NOT IN ('IS NULL', 'IS NOT NULL')) THEN
7636: rule := rule || ' ' || rules_rec.expression;
7637: END IF;
7638: ELSE
7639: rule := rule || '(SELECT value FORM csc_prof_block_results WHERE block_id = '
7640: ||
7641: rules_rec.expr_to_block_id || ' AND party_id = :party_id' ||
7642: ' AND cust_account_id = :cust_account_id)' ;
7643: END IF;

Line 7654: 'EXISTS (SELECT 1 FROM csc_prof_block_results WHERE block_id = ' ||

7650:
7651: FOR rules_rec IN rules_csr LOOP
7652: rule := rule || ' ' || rules_rec.logical_operator || ' ' ||
7653: rules_rec.left_paren ||
7654: 'EXISTS (SELECT 1 FROM csc_prof_block_results WHERE block_id = ' ||
7655: rules_rec.block_id || ' AND party_id = :party_id' ||
7656: ' AND cust_account_id IS NULL AND value ' || rules_rec.comparison_operator;
7657:
7658: IF rules_rec.expression IS NOT NULL THEN

Line 7663: rule := rule || '(SELECT value FORM csc_prof_block_results WHERE block_id = '||

7659: IF (rules_rec.comparison_operator NOT IN ('IS NULL', 'IS NOT NULL')) THEN
7660: rule := rule || ' ' || rules_rec.expression;
7661: END IF;
7662: ELSE
7663: rule := rule || '(SELECT value FORM csc_prof_block_results WHERE block_id = '||
7664: rules_rec.expr_to_block_id || ' AND cust_account_id IS NULL )';
7665: END IF;
7666:
7667: rule := rule || ')' || rules_rec.right_paren;