APPS.CN_SCA_CRRULEATTR_PVT dependencies on CN_REPOSITORIES

Line 407: UPDATE cn_repositories

403: x_Last_Update_Login => l_last_update_login
404: );
405:
406: IF l_credit_rule_attr_rec.transaction_source = 'CN' THEN
407: UPDATE cn_repositories
408: SET sca_mapping_status = 'UNSYNC'
409: WHERE org_id = p_org_id; -- MOAC Change
410: END IF;
411:

Line 599: update cn_repositories

595: X_ORG_ID => p_org_id, -- MOAC Change
596: X_SCA_RULE_ATTRIBUTE_ID => l_credit_rule_attr_rec.sca_rule_attribute_id) ;
597:
598: IF l_credit_rule_attr_rec.transaction_source = 'CN' THEN
599: update cn_repositories
600: set sca_mapping_status = 'UNSYNC'
601: where org_id = p_org_id; -- MOAC Change
602: END IF;
603: ELSE

Line 687: update cn_repositories

683:
684:
685: IF l_credit_rule_attr_rec.source_column <> l_trx_source_column AND l_credit_rule_attr_rec.transaction_source = 'CN'
686: THEN
687: update cn_repositories
688: set sca_mapping_status = 'UNSYNC'
689: where org_id = p_org_id;
690: END IF;
691: ELSE

Line 849: update cn_repositories

845: RAISE FND_API.G_EXC_ERROR;
846: -- x_loading_status := l_loading_status;
847:
848: ELSE
849: update cn_repositories
850: set sca_mapping_status='GENERATED'
851: WHERE org_id = p_org_id; -- MOAC Change
852:
853: END IF;