DBA Data[Home] [Help]

APPS.CN_IMP_RULE_PVT dependencies on CN_IMP_LINES

Line 32: l_stage_status cn_imp_lines.status_code%TYPE := 'STAGE';

28: p_org_id IN NUMBER
29: ) IS
30: l_api_name CONSTANT VARCHAR2(30) := 'Rules_Import';
31:
32: l_stage_status cn_imp_lines.status_code%TYPE := 'STAGE';
33: l_imp_header cn_imp_headers_pvt.imp_headers_rec_type := cn_imp_headers_pvt.G_MISS_IMP_HEADERS_REC;
34: l_processed_row NUMBER := 0;
35: l_failed_row NUMBER := 0;
36: l_message VARCHAR2(4000);

Line 371: -- This procedure will set error in cn_imp_lines(cn_rules_imp_v)

367:
368: -- --------------------------------------------------------+
369: -- seterr_imp_rules
370: --
371: -- This procedure will set error in cn_imp_lines(cn_rules_imp_v)
372: -- with passed in status and error code
373: -- --------------------------------------------------------+
374: PROCEDURE seterr_imp_rules
375: (p_status IN VARCHAR2,

Line 461: l_stage_status cn_imp_lines.status_code%TYPE := 'STAGE';

457: x_processed_row IN OUT NOCOPY NUMBER,
458: p_org_id IN NUMBER
459: ) IS
460: l_api_name CONSTANT VARCHAR2(30) := 'load_rules';
461: l_stage_status cn_imp_lines.status_code%TYPE := 'STAGE';
462: l_loading_status VARCHAR2(30);
463: l_return_status VARCHAR2(30);
464: l_msg_count NUMBER;
465: l_msg_data VARCHAR2(4000);

Line 996: l_stage_status cn_imp_lines.status_code%TYPE := 'STAGE';

992: x_processed_row IN OUT NOCOPY NUMBER,
993: p_org_id IN NUMBER
994: ) IS
995: l_api_name CONSTANT VARCHAR2(30) := 'load_rule_attributes';
996: l_stage_status cn_imp_lines.status_code%TYPE := 'STAGE';
997: l_error_code VARCHAR2(30);
998: l_loading_status VARCHAR2(30);
999: l_return_status VARCHAR2(30);
1000: l_msg_count NUMBER;