96: x_message VARCHAR2(1000);
97: l_rules_cnt NUMBER;
98: l_sequence_id NUMBER;
99: l_qa_status VARCHAR2(1);
100: l_conc_pgm_desc FND_NEW_MESSAGES.message_text%TYPE;
101:
102:
103:
104: CURSOR csr_get_child_req_dtls IS
972: x_dev_phase VARCHAR2(1000);
973: x_dev_status VARCHAR2(1000);
974: x_message VARCHAR2(1000);
975: l_rules_cnt NUMBER;
976: l_conc_pgm_desc FND_NEW_MESSAGES.message_text%TYPE;
977:
978: CURSOR csr_get_child_req_dtls IS
979: SELECT SUBSTR(req_data,
980: 1,
1879: x_message VARCHAR2(1000);
1880: l_rules_cnt NUMBER;
1881: l_sequence_id NUMBER;
1882: l_qa_status VARCHAR2(1);
1883: l_conc_pgm_desc FND_NEW_MESSAGES.message_text%TYPE;
1884:
1885:
1886: CURSOR csr_get_child_req_dtls IS
1887: SELECT SUBSTR(req_data,