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.IBC_CITEM_ADMIN_GRP dependencies on DBMS_SQL

Line 4659: cursor_id := DBMS_SQL.OPEN_CURSOR;

4655: /*
4656: -- sanshuma : 25-NOV-2004 : commenting out copy associations to fix bug#4020980.
4657:
4658: -- looping through all components of this attribute type
4659: cursor_id := DBMS_SQL.OPEN_CURSOR;
4660: DBMS_SQL.PARSE(cursor_id,associations, DBMS_SQL.V7);
4661: -- bind variables
4662: DBMS_SQL.BIND_VARIABLE(cursor_id,':CID',px_content_item_id);
4663: DBMS_SQL.BIND_VARIABLE(cursor_id,':CIVID',px_citem_ver_id);

Line 4660: DBMS_SQL.PARSE(cursor_id,associations, DBMS_SQL.V7);

4656: -- sanshuma : 25-NOV-2004 : commenting out copy associations to fix bug#4020980.
4657:
4658: -- looping through all components of this attribute type
4659: cursor_id := DBMS_SQL.OPEN_CURSOR;
4660: DBMS_SQL.PARSE(cursor_id,associations, DBMS_SQL.V7);
4661: -- bind variables
4662: DBMS_SQL.BIND_VARIABLE(cursor_id,':CID',px_content_item_id);
4663: DBMS_SQL.BIND_VARIABLE(cursor_id,':CIVID',px_citem_ver_id);
4664: -- define output variables

Line 4662: DBMS_SQL.BIND_VARIABLE(cursor_id,':CID',px_content_item_id);

4658: -- looping through all components of this attribute type
4659: cursor_id := DBMS_SQL.OPEN_CURSOR;
4660: DBMS_SQL.PARSE(cursor_id,associations, DBMS_SQL.V7);
4661: -- bind variables
4662: DBMS_SQL.BIND_VARIABLE(cursor_id,':CID',px_content_item_id);
4663: DBMS_SQL.BIND_VARIABLE(cursor_id,':CIVID',px_citem_ver_id);
4664: -- define output variables
4665: DBMS_SQL.DEFINE_COLUMN(cursor_id, 1, atc, 100);
4666: DBMS_SQL.DEFINE_COLUMN(cursor_id, 2, aov1, 254);

Line 4663: DBMS_SQL.BIND_VARIABLE(cursor_id,':CIVID',px_citem_ver_id);

4659: cursor_id := DBMS_SQL.OPEN_CURSOR;
4660: DBMS_SQL.PARSE(cursor_id,associations, DBMS_SQL.V7);
4661: -- bind variables
4662: DBMS_SQL.BIND_VARIABLE(cursor_id,':CID',px_content_item_id);
4663: DBMS_SQL.BIND_VARIABLE(cursor_id,':CIVID',px_citem_ver_id);
4664: -- define output variables
4665: DBMS_SQL.DEFINE_COLUMN(cursor_id, 1, atc, 100);
4666: DBMS_SQL.DEFINE_COLUMN(cursor_id, 2, aov1, 254);
4667: DBMS_SQL.DEFINE_COLUMN(cursor_id, 3, aov2, 254);

Line 4665: DBMS_SQL.DEFINE_COLUMN(cursor_id, 1, atc, 100);

4661: -- bind variables
4662: DBMS_SQL.BIND_VARIABLE(cursor_id,':CID',px_content_item_id);
4663: DBMS_SQL.BIND_VARIABLE(cursor_id,':CIVID',px_citem_ver_id);
4664: -- define output variables
4665: DBMS_SQL.DEFINE_COLUMN(cursor_id, 1, atc, 100);
4666: DBMS_SQL.DEFINE_COLUMN(cursor_id, 2, aov1, 254);
4667: DBMS_SQL.DEFINE_COLUMN(cursor_id, 3, aov2, 254);
4668: DBMS_SQL.DEFINE_COLUMN(cursor_id, 4, aov3, 254);
4669: DBMS_SQL.DEFINE_COLUMN(cursor_id, 5, aov4, 254);

Line 4666: DBMS_SQL.DEFINE_COLUMN(cursor_id, 2, aov1, 254);

4662: DBMS_SQL.BIND_VARIABLE(cursor_id,':CID',px_content_item_id);
4663: DBMS_SQL.BIND_VARIABLE(cursor_id,':CIVID',px_citem_ver_id);
4664: -- define output variables
4665: DBMS_SQL.DEFINE_COLUMN(cursor_id, 1, atc, 100);
4666: DBMS_SQL.DEFINE_COLUMN(cursor_id, 2, aov1, 254);
4667: DBMS_SQL.DEFINE_COLUMN(cursor_id, 3, aov2, 254);
4668: DBMS_SQL.DEFINE_COLUMN(cursor_id, 4, aov3, 254);
4669: DBMS_SQL.DEFINE_COLUMN(cursor_id, 5, aov4, 254);
4670: DBMS_SQL.DEFINE_COLUMN(cursor_id, 6, aov5, 254);

Line 4667: DBMS_SQL.DEFINE_COLUMN(cursor_id, 3, aov2, 254);

4663: DBMS_SQL.BIND_VARIABLE(cursor_id,':CIVID',px_citem_ver_id);
4664: -- define output variables
4665: DBMS_SQL.DEFINE_COLUMN(cursor_id, 1, atc, 100);
4666: DBMS_SQL.DEFINE_COLUMN(cursor_id, 2, aov1, 254);
4667: DBMS_SQL.DEFINE_COLUMN(cursor_id, 3, aov2, 254);
4668: DBMS_SQL.DEFINE_COLUMN(cursor_id, 4, aov3, 254);
4669: DBMS_SQL.DEFINE_COLUMN(cursor_id, 5, aov4, 254);
4670: DBMS_SQL.DEFINE_COLUMN(cursor_id, 6, aov5, 254);
4671:

Line 4668: DBMS_SQL.DEFINE_COLUMN(cursor_id, 4, aov3, 254);

4664: -- define output variables
4665: DBMS_SQL.DEFINE_COLUMN(cursor_id, 1, atc, 100);
4666: DBMS_SQL.DEFINE_COLUMN(cursor_id, 2, aov1, 254);
4667: DBMS_SQL.DEFINE_COLUMN(cursor_id, 3, aov2, 254);
4668: DBMS_SQL.DEFINE_COLUMN(cursor_id, 4, aov3, 254);
4669: DBMS_SQL.DEFINE_COLUMN(cursor_id, 5, aov4, 254);
4670: DBMS_SQL.DEFINE_COLUMN(cursor_id, 6, aov5, 254);
4671:
4672: -- executing cursor

Line 4669: DBMS_SQL.DEFINE_COLUMN(cursor_id, 5, aov4, 254);

4665: DBMS_SQL.DEFINE_COLUMN(cursor_id, 1, atc, 100);
4666: DBMS_SQL.DEFINE_COLUMN(cursor_id, 2, aov1, 254);
4667: DBMS_SQL.DEFINE_COLUMN(cursor_id, 3, aov2, 254);
4668: DBMS_SQL.DEFINE_COLUMN(cursor_id, 4, aov3, 254);
4669: DBMS_SQL.DEFINE_COLUMN(cursor_id, 5, aov4, 254);
4670: DBMS_SQL.DEFINE_COLUMN(cursor_id, 6, aov5, 254);
4671:
4672: -- executing cursor
4673: cursor_return := DBMS_SQL.EXECUTE(cursor_id);

Line 4670: DBMS_SQL.DEFINE_COLUMN(cursor_id, 6, aov5, 254);

4666: DBMS_SQL.DEFINE_COLUMN(cursor_id, 2, aov1, 254);
4667: DBMS_SQL.DEFINE_COLUMN(cursor_id, 3, aov2, 254);
4668: DBMS_SQL.DEFINE_COLUMN(cursor_id, 4, aov3, 254);
4669: DBMS_SQL.DEFINE_COLUMN(cursor_id, 5, aov4, 254);
4670: DBMS_SQL.DEFINE_COLUMN(cursor_id, 6, aov5, 254);
4671:
4672: -- executing cursor
4673: cursor_return := DBMS_SQL.EXECUTE(cursor_id);
4674:

Line 4673: cursor_return := DBMS_SQL.EXECUTE(cursor_id);

4669: DBMS_SQL.DEFINE_COLUMN(cursor_id, 5, aov4, 254);
4670: DBMS_SQL.DEFINE_COLUMN(cursor_id, 6, aov5, 254);
4671:
4672: -- executing cursor
4673: cursor_return := DBMS_SQL.EXECUTE(cursor_id);
4674:
4675: -- VALIDATION LOOP
4676: LOOP
4677: IF (DBMS_SQL.FETCH_ROWS(cursor_id) = 0) THEN

Line 4677: IF (DBMS_SQL.FETCH_ROWS(cursor_id) = 0) THEN

4673: cursor_return := DBMS_SQL.EXECUTE(cursor_id);
4674:
4675: -- VALIDATION LOOP
4676: LOOP
4677: IF (DBMS_SQL.FETCH_ROWS(cursor_id) = 0) THEN
4678: EXIT;
4679: END IF;
4680:
4681: --resetting id

Line 4685: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, atc);

4681: --resetting id
4682: assoc_id := null;
4683:
4684: -- loading column values
4685: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, atc);
4686: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, aov1);
4687: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, aov2);
4688: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, aov3);
4689: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, aov4);

Line 4686: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, aov1);

4682: assoc_id := null;
4683:
4684: -- loading column values
4685: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, atc);
4686: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, aov1);
4687: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, aov2);
4688: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, aov3);
4689: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, aov4);
4690: DBMS_SQL.COLUMN_VALUE(cursor_id, 6, aov5);

Line 4687: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, aov2);

4683:
4684: -- loading column values
4685: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, atc);
4686: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, aov1);
4687: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, aov2);
4688: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, aov3);
4689: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, aov4);
4690: DBMS_SQL.COLUMN_VALUE(cursor_id, 6, aov5);
4691: DBMS_SQL.COLUMN_VALUE(cursor_id, 7, civid);

Line 4688: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, aov3);

4684: -- loading column values
4685: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, atc);
4686: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, aov1);
4687: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, aov2);
4688: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, aov3);
4689: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, aov4);
4690: DBMS_SQL.COLUMN_VALUE(cursor_id, 6, aov5);
4691: DBMS_SQL.COLUMN_VALUE(cursor_id, 7, civid);
4692:

Line 4689: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, aov4);

4685: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, atc);
4686: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, aov1);
4687: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, aov2);
4688: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, aov3);
4689: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, aov4);
4690: DBMS_SQL.COLUMN_VALUE(cursor_id, 6, aov5);
4691: DBMS_SQL.COLUMN_VALUE(cursor_id, 7, civid);
4692:
4693:

Line 4690: DBMS_SQL.COLUMN_VALUE(cursor_id, 6, aov5);

4686: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, aov1);
4687: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, aov2);
4688: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, aov3);
4689: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, aov4);
4690: DBMS_SQL.COLUMN_VALUE(cursor_id, 6, aov5);
4691: DBMS_SQL.COLUMN_VALUE(cursor_id, 7, civid);
4692:
4693:
4694: IF civid IS NOT NULL THEN

Line 4691: DBMS_SQL.COLUMN_VALUE(cursor_id, 7, civid);

4687: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, aov2);
4688: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, aov3);
4689: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, aov4);
4690: DBMS_SQL.COLUMN_VALUE(cursor_id, 6, aov5);
4691: DBMS_SQL.COLUMN_VALUE(cursor_id, 7, civid);
4692:
4693:
4694: IF civid IS NOT NULL THEN
4695: civid := px_citem_ver_id;

Line 4716: DBMS_SQL.CLOSE_CURSOR(cursor_id);

4712:
4713:
4714: END LOOP;
4715: -- clean up!
4716: DBMS_SQL.CLOSE_CURSOR(cursor_id);
4717:
4718: */
4719:
4720: END IF; -- END ASSOCIATION COPYING

Line 5606: cursor_id := DBMS_SQL.OPEN_CURSOR;

5602: -- FINISHED BUILDING QUERY
5603:
5604:
5605: -- OPENING CURSOR
5606: cursor_id := DBMS_SQL.OPEN_CURSOR;
5607: DBMS_SQL.PARSE(cursor_id, A_LIST, DBMS_SQL.V7);
5608:
5609: -- SETTING BIND VARIABLES
5610: DBMS_SQL.BIND_VARIABLE(cursor_id,':ACODE',p_association_type_code);

Line 5607: DBMS_SQL.PARSE(cursor_id, A_LIST, DBMS_SQL.V7);

5603:
5604:
5605: -- OPENING CURSOR
5606: cursor_id := DBMS_SQL.OPEN_CURSOR;
5607: DBMS_SQL.PARSE(cursor_id, A_LIST, DBMS_SQL.V7);
5608:
5609: -- SETTING BIND VARIABLES
5610: DBMS_SQL.BIND_VARIABLE(cursor_id,':ACODE',p_association_type_code);
5611: DBMS_SQL.BIND_VARIABLE(cursor_id,':CITEM',p_content_item_id);

Line 5610: DBMS_SQL.BIND_VARIABLE(cursor_id,':ACODE',p_association_type_code);

5606: cursor_id := DBMS_SQL.OPEN_CURSOR;
5607: DBMS_SQL.PARSE(cursor_id, A_LIST, DBMS_SQL.V7);
5608:
5609: -- SETTING BIND VARIABLES
5610: DBMS_SQL.BIND_VARIABLE(cursor_id,':ACODE',p_association_type_code);
5611: DBMS_SQL.BIND_VARIABLE(cursor_id,':CITEM',p_content_item_id);
5612: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL1',p_associated_object_val1);
5613:
5614: -- SETTING REMAINING BIND VARIABLES ACCORDING TO IF THEY ARE USED OR NOT

Line 5611: DBMS_SQL.BIND_VARIABLE(cursor_id,':CITEM',p_content_item_id);

5607: DBMS_SQL.PARSE(cursor_id, A_LIST, DBMS_SQL.V7);
5608:
5609: -- SETTING BIND VARIABLES
5610: DBMS_SQL.BIND_VARIABLE(cursor_id,':ACODE',p_association_type_code);
5611: DBMS_SQL.BIND_VARIABLE(cursor_id,':CITEM',p_content_item_id);
5612: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL1',p_associated_object_val1);
5613:
5614: -- SETTING REMAINING BIND VARIABLES ACCORDING TO IF THEY ARE USED OR NOT
5615: IF (p_associated_object_val2 IS NOT NULL) THEN

Line 5612: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL1',p_associated_object_val1);

5608:
5609: -- SETTING BIND VARIABLES
5610: DBMS_SQL.BIND_VARIABLE(cursor_id,':ACODE',p_association_type_code);
5611: DBMS_SQL.BIND_VARIABLE(cursor_id,':CITEM',p_content_item_id);
5612: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL1',p_associated_object_val1);
5613:
5614: -- SETTING REMAINING BIND VARIABLES ACCORDING TO IF THEY ARE USED OR NOT
5615: IF (p_associated_object_val2 IS NOT NULL) THEN
5616: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL2',p_associated_object_val2);

Line 5616: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL2',p_associated_object_val2);

5612: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL1',p_associated_object_val1);
5613:
5614: -- SETTING REMAINING BIND VARIABLES ACCORDING TO IF THEY ARE USED OR NOT
5615: IF (p_associated_object_val2 IS NOT NULL) THEN
5616: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL2',p_associated_object_val2);
5617: END IF;
5618: IF (p_associated_object_val3 IS NOT NULL) THEN
5619: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL3',p_associated_object_val3);
5620: END IF;

Line 5619: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL3',p_associated_object_val3);

5615: IF (p_associated_object_val2 IS NOT NULL) THEN
5616: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL2',p_associated_object_val2);
5617: END IF;
5618: IF (p_associated_object_val3 IS NOT NULL) THEN
5619: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL3',p_associated_object_val3);
5620: END IF;
5621: IF (p_associated_object_val4 IS NOT NULL) THEN
5622: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL4',p_associated_object_val4);
5623: END IF;

Line 5622: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL4',p_associated_object_val4);

5618: IF (p_associated_object_val3 IS NOT NULL) THEN
5619: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL3',p_associated_object_val3);
5620: END IF;
5621: IF (p_associated_object_val4 IS NOT NULL) THEN
5622: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL4',p_associated_object_val4);
5623: END IF;
5624: IF (p_associated_object_val5 IS NOT NULL) THEN
5625: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL5',p_associated_object_val5);
5626: END IF;

Line 5625: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL5',p_associated_object_val5);

5621: IF (p_associated_object_val4 IS NOT NULL) THEN
5622: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL4',p_associated_object_val4);
5623: END IF;
5624: IF (p_associated_object_val5 IS NOT NULL) THEN
5625: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL5',p_associated_object_val5);
5626: END IF;
5627:
5628: -- DEFINING OUTPUT VARIABLE
5629: DBMS_SQL.DEFINE_COLUMN(cursor_id, 1, aid);

Line 5629: DBMS_SQL.DEFINE_COLUMN(cursor_id, 1, aid);

5625: DBMS_SQL.BIND_VARIABLE(cursor_id,':VAL5',p_associated_object_val5);
5626: END IF;
5627:
5628: -- DEFINING OUTPUT VARIABLE
5629: DBMS_SQL.DEFINE_COLUMN(cursor_id, 1, aid);
5630:
5631: -- executing cursor
5632: cursor_return := DBMS_SQL.EXECUTE(cursor_id);
5633:

Line 5632: cursor_return := DBMS_SQL.EXECUTE(cursor_id);

5628: -- DEFINING OUTPUT VARIABLE
5629: DBMS_SQL.DEFINE_COLUMN(cursor_id, 1, aid);
5630:
5631: -- executing cursor
5632: cursor_return := DBMS_SQL.EXECUTE(cursor_id);
5633:
5634: -- LOOPING FOR EACH ASSOCIATION FOUND MATCHING CRITERIA
5635: LOOP
5636: IF (DBMS_SQL.FETCH_ROWS(cursor_id) = 0) THEN

Line 5636: IF (DBMS_SQL.FETCH_ROWS(cursor_id) = 0) THEN

5632: cursor_return := DBMS_SQL.EXECUTE(cursor_id);
5633:
5634: -- LOOPING FOR EACH ASSOCIATION FOUND MATCHING CRITERIA
5635: LOOP
5636: IF (DBMS_SQL.FETCH_ROWS(cursor_id) = 0) THEN
5637: EXIT;
5638: END IF;
5639:
5640: -- setting flag that at least one was found

Line 5644: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, aid);

5640: -- setting flag that at least one was found
5641: counter := counter+1;
5642:
5643: -- loading column values
5644: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, aid);
5645:
5646: Ibc_Associations_Pkg.delete_row(
5647: p_association_id => aid
5648: );

Line 5679: DBMS_SQL.CLOSE_CURSOR(cursor_id);

5675: --***************************************************
5676:
5677: END LOOP;
5678: -- clean up!
5679: DBMS_SQL.CLOSE_CURSOR(cursor_id);
5680:
5681: END IF;
5682:
5683: IF (counter = 0) THEN