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.WMS_ATF_REG_CUST_APIS dependencies on DBMS_DESCRIBE

Line 23: -- Error Exceptions which can be raised by dbms_describe.describe_procedure

19: --
20: c_default_defined constant number default 1;
21: --
22: --
23: -- Error Exceptions which can be raised by dbms_describe.describe_procedure
24: --
25: --
26: -- Specified Object does not exist
27: --

Line 1216: l_overload dbms_describe.number_table;

1212: --
1213: -- Local variables to catch the values returned from
1214: -- describe_procedure
1215: --
1216: l_overload dbms_describe.number_table;
1217: l_position dbms_describe.number_table;
1218: l_level dbms_describe.number_table;
1219: l_argument_name dbms_describe.varchar2_table;
1220: l_datatype dbms_describe.number_table;

Line 1217: l_position dbms_describe.number_table;

1213: -- Local variables to catch the values returned from
1214: -- describe_procedure
1215: --
1216: l_overload dbms_describe.number_table;
1217: l_position dbms_describe.number_table;
1218: l_level dbms_describe.number_table;
1219: l_argument_name dbms_describe.varchar2_table;
1220: l_datatype dbms_describe.number_table;
1221: l_default_value dbms_describe.number_table;

Line 1218: l_level dbms_describe.number_table;

1214: -- describe_procedure
1215: --
1216: l_overload dbms_describe.number_table;
1217: l_position dbms_describe.number_table;
1218: l_level dbms_describe.number_table;
1219: l_argument_name dbms_describe.varchar2_table;
1220: l_datatype dbms_describe.number_table;
1221: l_default_value dbms_describe.number_table;
1222: l_in_out dbms_describe.number_table;

Line 1219: l_argument_name dbms_describe.varchar2_table;

1215: --
1216: l_overload dbms_describe.number_table;
1217: l_position dbms_describe.number_table;
1218: l_level dbms_describe.number_table;
1219: l_argument_name dbms_describe.varchar2_table;
1220: l_datatype dbms_describe.number_table;
1221: l_default_value dbms_describe.number_table;
1222: l_in_out dbms_describe.number_table;
1223: l_length dbms_describe.number_table;

Line 1220: l_datatype dbms_describe.number_table;

1216: l_overload dbms_describe.number_table;
1217: l_position dbms_describe.number_table;
1218: l_level dbms_describe.number_table;
1219: l_argument_name dbms_describe.varchar2_table;
1220: l_datatype dbms_describe.number_table;
1221: l_default_value dbms_describe.number_table;
1222: l_in_out dbms_describe.number_table;
1223: l_length dbms_describe.number_table;
1224: l_precision dbms_describe.number_table;

Line 1221: l_default_value dbms_describe.number_table;

1217: l_position dbms_describe.number_table;
1218: l_level dbms_describe.number_table;
1219: l_argument_name dbms_describe.varchar2_table;
1220: l_datatype dbms_describe.number_table;
1221: l_default_value dbms_describe.number_table;
1222: l_in_out dbms_describe.number_table;
1223: l_length dbms_describe.number_table;
1224: l_precision dbms_describe.number_table;
1225: l_scale dbms_describe.number_table;

Line 1222: l_in_out dbms_describe.number_table;

1218: l_level dbms_describe.number_table;
1219: l_argument_name dbms_describe.varchar2_table;
1220: l_datatype dbms_describe.number_table;
1221: l_default_value dbms_describe.number_table;
1222: l_in_out dbms_describe.number_table;
1223: l_length dbms_describe.number_table;
1224: l_precision dbms_describe.number_table;
1225: l_scale dbms_describe.number_table;
1226: l_radix dbms_describe.number_table;

Line 1223: l_length dbms_describe.number_table;

1219: l_argument_name dbms_describe.varchar2_table;
1220: l_datatype dbms_describe.number_table;
1221: l_default_value dbms_describe.number_table;
1222: l_in_out dbms_describe.number_table;
1223: l_length dbms_describe.number_table;
1224: l_precision dbms_describe.number_table;
1225: l_scale dbms_describe.number_table;
1226: l_radix dbms_describe.number_table;
1227: l_spare dbms_describe.number_table;

Line 1224: l_precision dbms_describe.number_table;

1220: l_datatype dbms_describe.number_table;
1221: l_default_value dbms_describe.number_table;
1222: l_in_out dbms_describe.number_table;
1223: l_length dbms_describe.number_table;
1224: l_precision dbms_describe.number_table;
1225: l_scale dbms_describe.number_table;
1226: l_radix dbms_describe.number_table;
1227: l_spare dbms_describe.number_table;
1228:

Line 1225: l_scale dbms_describe.number_table;

1221: l_default_value dbms_describe.number_table;
1222: l_in_out dbms_describe.number_table;
1223: l_length dbms_describe.number_table;
1224: l_precision dbms_describe.number_table;
1225: l_scale dbms_describe.number_table;
1226: l_radix dbms_describe.number_table;
1227: l_spare dbms_describe.number_table;
1228:
1229: --

Line 1226: l_radix dbms_describe.number_table;

1222: l_in_out dbms_describe.number_table;
1223: l_length dbms_describe.number_table;
1224: l_precision dbms_describe.number_table;
1225: l_scale dbms_describe.number_table;
1226: l_radix dbms_describe.number_table;
1227: l_spare dbms_describe.number_table;
1228:
1229: --
1230: -- Variable to store the parameter table passed out from the call to

Line 1227: l_spare dbms_describe.number_table;

1223: l_length dbms_describe.number_table;
1224: l_precision dbms_describe.number_table;
1225: l_scale dbms_describe.number_table;
1226: l_radix dbms_describe.number_table;
1227: l_spare dbms_describe.number_table;
1228:
1229: --
1230: -- Variable to store the parameter table passed out from the call to
1231: -- populate_parameter_table

Line 1330: trace(l_proc||' Before Calling dbms_describe.describe_procedure...', 4);

1326: end if;
1327:
1328: if (l_debug = 1) then
1329: trace(l_proc||' Passed Progress :'|| l_prog);
1330: trace(l_proc||' Before Calling dbms_describe.describe_procedure...', 4);
1331: end if;
1332:
1333: l_prog := 53.4;
1334:

Line 1335: dbms_describe.describe_procedure(

1331: end if;
1332:
1333: l_prog := 53.4;
1334:
1335: dbms_describe.describe_procedure(
1336: object_name => l_object_name
1337: , reserved1 => null
1338: , reserved2 => null
1339: , overload => l_overload

Line 1408: trace(l_proc|| ' After Calling dbms_describe.describe_procedure...', 4);

1404:
1405: l_prog := 53.5;
1406: if (l_debug = 1) then
1407: trace(l_proc|| ' Passed Progress :'|| l_prog);
1408: trace(l_proc|| ' After Calling dbms_describe.describe_procedure...', 4);
1409: end if;
1410: exception
1411: when Package_Not_Exists then
1412: -- Error: The call_package does not exist in the database. Code to

Line 1723: l_overload dbms_describe.number_table;

1719: --
1720: -- Local variables to catch the values returned from
1721: -- describe_procedure
1722: --
1723: l_overload dbms_describe.number_table;
1724: l_position dbms_describe.number_table;
1725: l_level dbms_describe.number_table;
1726: l_argument_name dbms_describe.varchar2_table;
1727: l_datatype dbms_describe.number_table;

Line 1724: l_position dbms_describe.number_table;

1720: -- Local variables to catch the values returned from
1721: -- describe_procedure
1722: --
1723: l_overload dbms_describe.number_table;
1724: l_position dbms_describe.number_table;
1725: l_level dbms_describe.number_table;
1726: l_argument_name dbms_describe.varchar2_table;
1727: l_datatype dbms_describe.number_table;
1728: l_default_value dbms_describe.number_table;

Line 1725: l_level dbms_describe.number_table;

1721: -- describe_procedure
1722: --
1723: l_overload dbms_describe.number_table;
1724: l_position dbms_describe.number_table;
1725: l_level dbms_describe.number_table;
1726: l_argument_name dbms_describe.varchar2_table;
1727: l_datatype dbms_describe.number_table;
1728: l_default_value dbms_describe.number_table;
1729: l_in_out dbms_describe.number_table;

Line 1726: l_argument_name dbms_describe.varchar2_table;

1722: --
1723: l_overload dbms_describe.number_table;
1724: l_position dbms_describe.number_table;
1725: l_level dbms_describe.number_table;
1726: l_argument_name dbms_describe.varchar2_table;
1727: l_datatype dbms_describe.number_table;
1728: l_default_value dbms_describe.number_table;
1729: l_in_out dbms_describe.number_table;
1730: l_length dbms_describe.number_table;

Line 1727: l_datatype dbms_describe.number_table;

1723: l_overload dbms_describe.number_table;
1724: l_position dbms_describe.number_table;
1725: l_level dbms_describe.number_table;
1726: l_argument_name dbms_describe.varchar2_table;
1727: l_datatype dbms_describe.number_table;
1728: l_default_value dbms_describe.number_table;
1729: l_in_out dbms_describe.number_table;
1730: l_length dbms_describe.number_table;
1731: l_precision dbms_describe.number_table;

Line 1728: l_default_value dbms_describe.number_table;

1724: l_position dbms_describe.number_table;
1725: l_level dbms_describe.number_table;
1726: l_argument_name dbms_describe.varchar2_table;
1727: l_datatype dbms_describe.number_table;
1728: l_default_value dbms_describe.number_table;
1729: l_in_out dbms_describe.number_table;
1730: l_length dbms_describe.number_table;
1731: l_precision dbms_describe.number_table;
1732: l_scale dbms_describe.number_table;

Line 1729: l_in_out dbms_describe.number_table;

1725: l_level dbms_describe.number_table;
1726: l_argument_name dbms_describe.varchar2_table;
1727: l_datatype dbms_describe.number_table;
1728: l_default_value dbms_describe.number_table;
1729: l_in_out dbms_describe.number_table;
1730: l_length dbms_describe.number_table;
1731: l_precision dbms_describe.number_table;
1732: l_scale dbms_describe.number_table;
1733: l_radix dbms_describe.number_table;

Line 1730: l_length dbms_describe.number_table;

1726: l_argument_name dbms_describe.varchar2_table;
1727: l_datatype dbms_describe.number_table;
1728: l_default_value dbms_describe.number_table;
1729: l_in_out dbms_describe.number_table;
1730: l_length dbms_describe.number_table;
1731: l_precision dbms_describe.number_table;
1732: l_scale dbms_describe.number_table;
1733: l_radix dbms_describe.number_table;
1734: l_spare dbms_describe.number_table;

Line 1731: l_precision dbms_describe.number_table;

1727: l_datatype dbms_describe.number_table;
1728: l_default_value dbms_describe.number_table;
1729: l_in_out dbms_describe.number_table;
1730: l_length dbms_describe.number_table;
1731: l_precision dbms_describe.number_table;
1732: l_scale dbms_describe.number_table;
1733: l_radix dbms_describe.number_table;
1734: l_spare dbms_describe.number_table;
1735:

Line 1732: l_scale dbms_describe.number_table;

1728: l_default_value dbms_describe.number_table;
1729: l_in_out dbms_describe.number_table;
1730: l_length dbms_describe.number_table;
1731: l_precision dbms_describe.number_table;
1732: l_scale dbms_describe.number_table;
1733: l_radix dbms_describe.number_table;
1734: l_spare dbms_describe.number_table;
1735:
1736: l_proc varchar2(72) := 'CREATE_DELETE_API_CALL :';

Line 1733: l_radix dbms_describe.number_table;

1729: l_in_out dbms_describe.number_table;
1730: l_length dbms_describe.number_table;
1731: l_precision dbms_describe.number_table;
1732: l_scale dbms_describe.number_table;
1733: l_radix dbms_describe.number_table;
1734: l_spare dbms_describe.number_table;
1735:
1736: l_proc varchar2(72) := 'CREATE_DELETE_API_CALL :';
1737: l_prog float;

Line 1734: l_spare dbms_describe.number_table;

1730: l_length dbms_describe.number_table;
1731: l_precision dbms_describe.number_table;
1732: l_scale dbms_describe.number_table;
1733: l_radix dbms_describe.number_table;
1734: l_spare dbms_describe.number_table;
1735:
1736: l_proc varchar2(72) := 'CREATE_DELETE_API_CALL :';
1737: l_prog float;
1738:

Line 1912: trace(l_proc||' Before Calling dbms_describe.describe_procedure...', 4);

1908: if (l_debug = 1) then
1909: trace(l_proc||' Passed Progress :'|| l_prog);
1910: trace(l_proc||' Within the if condition where the called package/procedure derived and passed in does not match...');
1911: trace(l_proc||' This combination does not exist and hence proceed with the Registration process.......', 4);
1912: trace(l_proc||' Before Calling dbms_describe.describe_procedure...', 4);
1913: end if;
1914:
1915: --
1916: -- Check if the call procedure exists in the call package in the database

Line 1920: dbms_describe.describe_procedure(

1916: -- Check if the call procedure exists in the call package in the database
1917: -- and if the package is valid. if the call package is invalid, try compiling
1918: -- it once, If successful proceed with the registration otherwise abort operation.
1919: l_prog := 51;
1920: dbms_describe.describe_procedure(
1921: object_name => p_call_package || '.' || p_call_procedure
1922: , reserved1 => null
1923: , reserved2 => null
1924: , overload => l_overload

Line 1974: -- DBMS_DESCRIBE.DESCRIBE_PROCEDURE succeeded so exit the loop.

1970: --
1971: raise Invalid_package;
1972: end;
1973: --
1974: -- DBMS_DESCRIBE.DESCRIBE_PROCEDURE succeeded so exit the loop.
1975: --
1976: end if;
1977:
1978: -- Validate the signature of the call procedure before inserting records in the