APPS.CN_SCA_CRRULEATTR_PKG dependencies on CN_SCA_RULE_ATTRIBUTES_ALL_B

Line 503: cursor C is select ROWID from CN_SCA_RULE_ATTRIBUTES_ALL_B

499: X_LAST_UPDATE_DATE in DATE,
500: X_LAST_UPDATED_BY in NUMBER,
501: X_LAST_UPDATE_LOGIN in NUMBER
502: ) is
503: cursor C is select ROWID from CN_SCA_RULE_ATTRIBUTES_ALL_B
504: where SCA_RULE_ATTRIBUTE_ID = X_SCA_RULE_ATTRIBUTE_ID
505: and org_id = x_org_id; -- MOAC Change
506: begin
507: insert into CN_SCA_RULE_ATTRIBUTES_ALL_B (

Line 507: insert into CN_SCA_RULE_ATTRIBUTES_ALL_B (

503: cursor C is select ROWID from CN_SCA_RULE_ATTRIBUTES_ALL_B
504: where SCA_RULE_ATTRIBUTE_ID = X_SCA_RULE_ATTRIBUTE_ID
505: and org_id = x_org_id; -- MOAC Change
506: begin
507: insert into CN_SCA_RULE_ATTRIBUTES_ALL_B (
508: ORG_ID, -- MOAC Change
509: SCA_RULE_ATTRIBUTE_ID,
510: TRANSACTION_SOURCE,
511: SRC_COLUMN_NAME,

Line 670: from CN_SCA_RULE_ATTRIBUTES_ALL_B

666: ATTRIBUTE14,
667: ATTRIBUTE15,
668: OBJECT_VERSION_NUMBER,
669: SECURITY_GROUP_ID
670: from CN_SCA_RULE_ATTRIBUTES_ALL_B
671: where SCA_RULE_ATTRIBUTE_ID = X_SCA_RULE_ATTRIBUTE_ID
672: and ORG_ID = X_ORG_ID -- MOAC Change
673: for update of SCA_RULE_ATTRIBUTE_ID nowait;
674: recinfo c%rowtype;

Line 792: update CN_SCA_RULE_ATTRIBUTES_ALL_B set

788: X_LAST_UPDATED_BY in NUMBER,
789: X_LAST_UPDATE_LOGIN in NUMBER
790: ) is
791: begin
792: update CN_SCA_RULE_ATTRIBUTES_ALL_B set
793: TRANSACTION_SOURCE = X_TRANSACTION_SOURCE,
794: SRC_COLUMN_NAME = X_SRC_COLUMN_NAME,
795: DATATYPE = X_DATATYPE,
796: VALUE_SET_ID = X_VALUE_SET_ID,

Line 855: delete from CN_SCA_RULE_ATTRIBUTES_ALL_B

851: if (sql%notfound) then
852: raise no_data_found;
853: end if;
854:
855: delete from CN_SCA_RULE_ATTRIBUTES_ALL_B
856: where SCA_RULE_ATTRIBUTE_ID = X_SCA_RULE_ATTRIBUTE_ID
857: and ORG_ID = X_ORG_ID; -- MOAC Change
858:
859: if (sql%notfound) then

Line 870: from CN_SCA_RULE_ATTRIBUTES_ALL_B B

866: begin
867: delete from CN_SCA_RULE_ATTRIBUTES_ALL_TL T
868: where not exists
869: (select NULL
870: from CN_SCA_RULE_ATTRIBUTES_ALL_B B
871: where B.SCA_RULE_ATTRIBUTE_ID = T.SCA_RULE_ATTRIBUTE_ID
872: and B.ORG_ID = T.ORG_ID -- MOAC Change
873: );
874:

Line 963: UPDATE cn_sca_rule_attributes_all_b SET

959: ELSE
960: user_id := 0;
961: END IF;
962: -- Load The record to _B table
963: UPDATE cn_sca_rule_attributes_all_b SET
964: last_update_date = sysdate,
965: last_updated_by = user_id,
966: last_update_login = 0
967: WHERE sca_rule_attribute_id = X_SCA_RULE_ATTRIBUTE_id

Line 972: INSERT INTO cn_sca_rule_attributes_all_b

968: AND org_id = x_org_id;
969:
970: IF (SQL%NOTFOUND) THEN
971: -- Insert new record to _B table
972: INSERT INTO cn_sca_rule_attributes_all_b
973: ( SCA_RULE_ATTRIBUTE_ID,
974: TRANSACTION_SOURCE,
975: SRC_COLUMN_NAME,
976: DATATYPE,