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 8639: -- result in the CSC_PROF_BLOCK_RESULTS table.

8635: /* End of R12 Employee HelpDesk Modifications */
8636: --
8637: -- Evaluate_One_Block
8638: -- Execute dynamic SQL to evaluate the given building block and store the
8639: -- result in the CSC_PROF_BLOCK_RESULTS table.
8640: -- IN
8641: -- blk_id - profile check building block identifier
8642: -- party_id - customer identifier for which building block is evaluated
8643: -- acct_id - account id

Line 8684: From csc_prof_block_results

8680: /*
8681: -- for party level
8682: Cursor party_block_crs IS
8683: Select count(*)
8684: From csc_prof_block_results
8685: Where block_id = p_blk_id
8686: And party_id = p_party_id
8687: And cust_account_id IS NULL;
8688:

Line 8692: From csc_prof_block_results

8688:
8689: -- for account level
8690: Cursor account_block_crs IS
8691: Select count(*)
8692: From csc_prof_block_results
8693: Where block_id = p_blk_id
8694: And party_id = p_party_id
8695: And cust_account_id = p_acct_id;
8696: */

Line 8769: select 1 into v_party_count from csc_prof_block_results

8765: If p_psite_id IS NULL THEN -- Added by spamujul for NCR ER#8473903
8766: IF p_acct_id IS NULL THEN
8767: IF p_truncate_flag = 'N' THEN
8768: begin
8769: select 1 into v_party_count from csc_prof_block_results
8770: where block_id = p_blk_id
8771: and party_id = p_party_id
8772: and cust_account_id is null
8773: and party_site_id is NULL -- Added by spamujul for ER#8473903

Line 8836: select 1 into v_account_count from csc_prof_block_results

8832: END IF;
8833: ELSE
8834: IF p_truncate_flag = 'N' THEN
8835: begin
8836: select 1 into v_account_count from csc_prof_block_results
8837: where block_id = p_blk_id
8838: and party_id = p_party_id
8839: and cust_account_id = p_acct_id
8840: and party_site_id is null -- Added by spamujul for ER#8473903

Line 8905: select 1 into v_psite_count from csc_prof_block_results

8901: -- Begin fix by spamujul fro NCR ER#8473903
8902: ELSE
8903: IF p_truncate_flag = 'N' THEN
8904: begin
8905: select 1 into v_psite_count from csc_prof_block_results
8906: where block_id = p_blk_id
8907: and party_id = p_party_id
8908: and cust_account_id IS NULL
8909: and party_site_id =p_psite_id ;

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

8977: END Evaluate_One_Block;
8978:
8979:
8980: --
8981: -- Insert or Update Records into Csc_Prof_Block_Results Table
8982: -- IN
8983: -- p_count - the number of records to be inserted or updated
8984: -- p_for_party - flag to check if the insert or update is for party or account
8985: -- p_for_insert - flag to check if for insert or update.

Line 9010: -- Insert Records into Csc_Prof_Block_Results Table

9006: IF P_FOR_PSITE ='N' Then -- Added by spamujul for ER#8473903
9007: IF p_for_party = 'Y' THEN
9008: -- PARTY level insert or update of records
9009: IF p_for_insert = 'Y' THEN
9010: -- Insert Records into Csc_Prof_Block_Results Table
9011: FORALL i IN 1..p_count
9012: INSERT INTO Csc_Prof_Block_Results
9013: ( block_results_id
9014: , block_id

Line 9012: INSERT INTO Csc_Prof_Block_Results

9008: -- PARTY level insert or update of records
9009: IF p_for_insert = 'Y' THEN
9010: -- Insert Records into Csc_Prof_Block_Results Table
9011: FORALL i IN 1..p_count
9012: INSERT INTO Csc_Prof_Block_Results
9013: ( block_results_id
9014: , block_id
9015: , party_id
9016: , cust_account_id

Line 9026: (csc_prof_block_results_s.nextval

9022: , last_updated_by
9023: , last_update_date
9024: , last_update_login)
9025: VALUES
9026: (csc_prof_block_results_s.nextval
9027: , ip_block_id(i)
9028: , ip_party_id(i)
9029: , ip_account_id(i)
9030: , ip_psite_id(i) -- Added by spamujul for ER#8473903

Line 9047: UPDATE Csc_Prof_Block_Results

9043: ip_value.DELETE;
9044: ip_currency.DELETE;
9045: ELSE
9046: FORALL i IN 1..p_count
9047: UPDATE Csc_Prof_Block_Results
9048: Set value = up_value(i)
9049: , currency_code = up_currency(i)
9050: , last_updated_by = FND_GLOBAL.USER_ID
9051: , last_update_date = sysdate

Line 9067: -- Insert Records into Csc_Prof_Block_Results Table

9063: END IF;
9064: ELSE
9065: -- ACCOUNT level insert or update of records
9066: IF p_for_insert = 'Y' THEN
9067: -- Insert Records into Csc_Prof_Block_Results Table
9068: FORALL i IN 1..p_count
9069: INSERT INTO Csc_Prof_Block_Results
9070: ( block_results_id
9071: , block_id

Line 9069: INSERT INTO Csc_Prof_Block_Results

9065: -- ACCOUNT level insert or update of records
9066: IF p_for_insert = 'Y' THEN
9067: -- Insert Records into Csc_Prof_Block_Results Table
9068: FORALL i IN 1..p_count
9069: INSERT INTO Csc_Prof_Block_Results
9070: ( block_results_id
9071: , block_id
9072: , party_id
9073: , cust_account_id

Line 9083: (csc_prof_block_results_s.nextval

9079: , last_updated_by
9080: , last_update_date
9081: , last_update_login)
9082: VALUES
9083: (csc_prof_block_results_s.nextval
9084: , ia_block_id(i)
9085: , ia_party_id(i)
9086: , ia_account_id(i)
9087: , ia_psite_id(i) -- Added by spamujul for ER#8473903

Line 9104: UPDATE Csc_Prof_Block_Results

9100: ia_value.DELETE;
9101: ia_currency.DELETE;
9102: ELSE
9103: FORALL i IN 1..p_count
9104: UPDATE Csc_Prof_Block_Results
9105: Set value = ua_value(i)
9106: , currency_code = ua_currency(i)
9107: , last_updated_by = FND_GLOBAL.USER_ID
9108: , last_update_date = sysdate

Line 9127: -- Insert Records into Csc_Prof_Block_Results Table

9123: END IF;
9124: -- Begin fix by spamujul for NCR ER# 8473903
9125: ELSE
9126: IF p_for_insert = 'Y' THEN
9127: -- Insert Records into Csc_Prof_Block_Results Table
9128: FORALL i IN 1..p_count
9129: INSERT INTO Csc_Prof_Block_Results
9130: ( block_results_id
9131: , block_id

Line 9129: INSERT INTO Csc_Prof_Block_Results

9125: ELSE
9126: IF p_for_insert = 'Y' THEN
9127: -- Insert Records into Csc_Prof_Block_Results Table
9128: FORALL i IN 1..p_count
9129: INSERT INTO Csc_Prof_Block_Results
9130: ( block_results_id
9131: , block_id
9132: , party_id
9133: , cust_account_id

Line 9144: (csc_prof_block_results_s.nextval

9140: , last_update_login
9141: , party_site_id
9142: )
9143: VALUES
9144: (csc_prof_block_results_s.nextval
9145: , is_block_id(i)
9146: , is_party_id(i)
9147: , is_account_id(i)
9148: , is_value(i)

Line 9165: UPDATE Csc_Prof_Block_Results

9161: is_value.DELETE;
9162: is_currency.DELETE;
9163: ELSE
9164: FORALL i IN 1..p_count
9165: UPDATE Csc_Prof_Block_Results
9166: Set value = us_value(i)
9167: , currency_code = us_currency(i)
9168: , last_updated_by = FND_GLOBAL.USER_ID
9169: , last_update_date = sysdate

Line 10308: -- FROM csc_prof_block_results

10304: -- EXISTS ( {subquery} )
10305: --
10306: -- A {subquery} has the following three forms:
10307: -- SELECT 1
10308: -- FROM csc_prof_block_results
10309: -- WHERE block_id =
10310: -- AND party_id =
10311: -- AND value [ [AND ]]
10312: --

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

10319: close blk_crs;
10320: if v_blk_level='PARTY' then
10321: rule := rule || ' ' || rules_rec.logical_operator || ' ' ||
10322: rules_rec.left_paren ||
10323: 'EXISTS (SELECT 1 FROM csc_prof_block_results WHERE block_id = ' ||
10324: rules_rec.block_id || ' AND party_id = :party_id' ||
10325: ' AND cust_account_id IS NULL AND party_site_id IS NULL AND value ' || rules_rec.comparison_operator; -- Included "PARTY_SITE_ID IS NULL" by spamujul for ER#8473903
10326: IF rules_rec.expression IS NOT NULL THEN
10327: IF (rules_rec.comparison_operator NOT IN ('IS NULL', 'IS NOT NULL')) THEN

Line 10331: rule := rule || '(SELECT value from csc_prof_block_results WHERE block_id = '||

10327: IF (rules_rec.comparison_operator NOT IN ('IS NULL', 'IS NOT NULL')) THEN
10328: rule := rule || ' ' || rules_rec.expression;
10329: END IF;
10330: ELSE
10331: rule := rule || '(SELECT value from csc_prof_block_results WHERE block_id = '||
10332: rules_rec.expr_to_block_id || ' AND cust_account_id IS NULL AND party_site_id IS NULL )'; -- Included "PARTY_SITE_ID IS NULL" by spamujul for ER#8473903
10333: END IF;
10334: rule := rule || ')' || rules_rec.right_paren;
10335: ELSIF v_blk_level='ACCOUNT' then

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

10334: rule := rule || ')' || rules_rec.right_paren;
10335: ELSIF v_blk_level='ACCOUNT' then
10336: rule := rule || ' ' || rules_rec.logical_operator || ' ' ||
10337: rules_rec.left_paren ||
10338: 'EXISTS (SELECT 1 FROM csc_prof_block_results WHERE block_id = ' ||
10339: rules_rec.block_id || ' AND party_id = :party_id' ||
10340: ' AND cust_account_id = :cust_account_id AND party_site_id IS NULL' || -- Included "PARTY_SITE_ID IS NULL" by spamujul for ER#8473903
10341: ' AND value ' || rules_rec.comparison_operator;
10342: IF rules_rec.expression IS NOT NULL THEN

Line 10347: rule := rule || '(SELECT value from csc_prof_block_results WHERE block_id = '

10343: IF (rules_rec.comparison_operator NOT IN ('IS NULL', 'IS NOT NULL')) THEN
10344: rule := rule || ' ' || rules_rec.expression;
10345: END IF;
10346: ELSE
10347: rule := rule || '(SELECT value from csc_prof_block_results WHERE block_id = '
10348: || rules_rec.expr_to_block_id || ' AND party_id = :party_id' ||
10349: ' AND cust_account_id = :cust_account_id AND party_site_id IS NULL )' ; -- Included "PARTY_SITE_ID IS NULL" by spamujul for ER#8473903
10350: END IF;
10351: rule := rule || ')' || rules_rec.right_paren;

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

10360: close blk_crs;
10361: IF v_blk_level='PARTY' THEN
10362: rule := rule || ' ' || rules_rec.logical_operator || ' ' ||
10363: rules_rec.left_paren ||
10364: 'EXISTS (SELECT 1 FROM csc_prof_block_results WHERE block_id = ' ||
10365: rules_rec.block_id || ' AND party_id = :party_id' ||
10366: ' AND cust_account_id IS NULL AND PARTY_SITE_ID IS NULL AND value ' || rules_rec.comparison_operator;
10367: IF rules_rec.expression IS NOT NULL THEN
10368: IF (rules_rec.comparison_operator NOT IN ('IS NULL', 'IS NOT NULL')) THEN

Line 10372: rule := rule || '(SELECT value from csc_prof_block_results WHERE block_id = '||

10368: IF (rules_rec.comparison_operator NOT IN ('IS NULL', 'IS NOT NULL')) THEN
10369: rule := rule || ' ' || rules_rec.expression;
10370: END IF;
10371: ELSE
10372: rule := rule || '(SELECT value from csc_prof_block_results WHERE block_id = '||
10373: rules_rec.expr_to_block_id || ' AND cust_account_id IS NULL AND PARTY_SITE_ID IS NULL)';
10374: END IF;
10375: rule := rule || ')' || rules_rec.right_paren;
10376: ELSIF v_blk_level='SITE' then

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

10375: rule := rule || ')' || rules_rec.right_paren;
10376: ELSIF v_blk_level='SITE' then
10377: rule := rule || ' ' || rules_rec.logical_operator || ' ' ||
10378: rules_rec.left_paren ||
10379: 'EXISTS (SELECT 1 FROM csc_prof_block_results WHERE block_id = ' ||
10380: rules_rec.block_id || ' AND party_id = :party_id' ||
10381: ' AND party_site_id = :party_site_id and cust_account_id is null' ||
10382: ' AND value ' || rules_rec.comparison_operator;
10383: IF rules_rec.expression IS NOT NULL THEN

Line 10388: rule := rule || '(SELECT value from csc_prof_block_results WHERE block_id = '

10384: IF (rules_rec.comparison_operator NOT IN ('IS NULL', 'IS NOT NULL')) THEN
10385: rule := rule || ' ' || rules_rec.expression;
10386: END IF;
10387: ELSE
10388: rule := rule || '(SELECT value from csc_prof_block_results WHERE block_id = '
10389: ||rules_rec.expr_to_block_id || ' AND party_id = :party_id' ||
10390: ' AND party_site_id = :party_site_id and cust_account_id is null)' ;
10391: END IF;
10392: rule := rule || ')' || rules_rec.right_paren;

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

10397: ELSIF (chk_level='PARTY' OR chk_level='CONTACT' or chk_level='EMPLOYEE') THEN
10398: FOR rules_rec IN rules_csr LOOP
10399: rule := rule || ' ' || rules_rec.logical_operator || ' ' ||
10400: rules_rec.left_paren ||
10401: 'EXISTS (SELECT 1 FROM csc_prof_block_results WHERE block_id = ' ||
10402: rules_rec.block_id || ' AND party_id = :party_id' ||
10403: ' AND cust_account_id IS NULL AND party_site_id IS NULL AND value ' || rules_rec.comparison_operator; -- Included "PARTY_SITE_ID IS NULL" by spamujul for ER#8473903
10404:
10405: IF rules_rec.expression IS NOT NULL THEN

Line 10410: rule := rule || '(SELECT value from csc_prof_block_results WHERE block_id = '||

10406: IF (rules_rec.comparison_operator NOT IN ('IS NULL', 'IS NOT NULL')) THEN
10407: rule := rule || ' ' || rules_rec.expression;
10408: END IF;
10409: ELSE
10410: rule := rule || '(SELECT value from csc_prof_block_results WHERE block_id = '||
10411: rules_rec.expr_to_block_id || ' AND cust_account_id IS NULL AND party_site_id IS NULL)'; -- Included "PARTY_SITE_ID IS NULL" by spamujul for ER#8473903
10412: END IF;
10413: rule := rule || ')' || rules_rec.right_paren;
10414: END LOOP;